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