The following code:

conn = win32com.client.Dispatch(r'ADODB.Connection')
DSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=%s;Jet
OLEDB:Database Password=root' % dbName
conn.Open(DSN)

gives:
com_error: (-2147352567, 'Exception occurred.', (0,
u'ADODB.Connection', u'Provider cannot be found. It may not be
properly installed.', u'C:\\Windows\\HELP\\ADO270.CHM', 1240655,
-2146824582), None)

I got the same error in visual studio and the solution is to set
compilation to 32bit since jet does not exist for vista-64bit. I have
python64 so how do I tell pywin to use the 32bit version?

thank you,
Gerdus
_______________________________________________
python-win32 mailing list
python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32

Reply via email to