Re: [python-win32] Vista64 Jet

2009-05-14 Thread Gerdus van Zyl
Ah, ok. Thank you. On Thu, May 14, 2009 at 12:24 AM, Mark Hammond skippy.hamm...@gmail.comwrote: On 11/05/2009 11:16 PM, Gerdus van Zyl wrote: 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

Re: [python-win32] Vista64 Jet

2009-05-13 Thread Mark Hammond
On 11/05/2009 11:16 PM, Gerdus van Zyl wrote: 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? You can't - you need to use the 32bit version of

[python-win32] Vista64 Jet

2009-05-11 Thread 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