python-win32 : cross database automation

[threaderslash]

Hello Everybody...

I working on a client-server database solution. The system is normalized and
is using MySQL. To automate some of processes I using Python. Part of the
old database will be still running on Lotus Notes.

After working on it, it seems that the best choice to directly manipulate
Lotus is to use Python with win32COM. I installed ActivePython 2.6
compiler, which comes with integrated win32com.

However, when I try to run.. it gives me the error: :captain:

--x--x--

ActivePython 2.6.2.2 (ActiveState Software Inc.) based on
Python 2.6.2 (r262:71600, Apr 21 2009, 15:05:37) [MSC v.1500 32 bit (Intel)]
on
win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import win32com.client
>>> sess=win32com.client.Dispatch("Lotus.NotesSession")
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "C:\dev\python\Py26\lib\site-packages\win32com\client\__init__.py",
line 95, in Dispatch
dispatch, userName =
dynamic._GetGoodDispatchAndUserName(dispatch,userName,clsctx)
File "C:\dev\python\Py26\lib\site-packages\win32com\client\dynamic.py", line
98, in _GetGoodDispatchAndUserN
ame
return (_GetGoodDispatch(IDispatch, clsctx), userName)
File "C:\dev\python\Py26\lib\site-packages\win32com\client\dynamic.py", line
78, in _GetGoodDispatch
IDispatch = pythoncom.CoCreateInstance(IDispatch, None, clsctx,
pythoncom.IID_IDispatch)
pywintypes.com_error: (-2147221005, 'Invalid class string', None, None)

--x--x--

Any suggestions? Some help is mostly appreciated. :mrgreen:

I will keep working to get it fixed, after I post the working solution here. :beer: