[python-win32] Vista64 Jet

[Gerdus van Zyl]

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