Monday, 15 February 2010

python - Error finding msaccess driver on windows parallel on a mac -



python - Error finding msaccess driver on windows parallel on a mac -

i'm using pyodbc acces msaccess database using python 2.7. i'm running windows 7 on parallels v10 on osx10.9. i'm using next code test it:

dbfile = 'c:\\dir\\testdb.db' conn = pyodbc.connect('driver={microsoft access driver (*.mdb)};dbq='+dbfile)

and cannot seem locate msaccess driver, resulting in next error:

> traceback (most recent phone call last): file "c:/projects/dbtest.py", > line 6, in <module> > conn = pyodbc.connect('driver={microsoft access driver (*.mdb)};dbq='+dbfile) error: ('hy024', "[hy024] [microsoft][odbc > microsoft access driver] '(unknown)' not valid path. create sure > path name spelled correctly , connected > server on file resides. (-1023) (sqldriverconnect); > [01000] [microsoft][odbc microsoft access driver]general warning > unable open registry key 'temporary (volatile) jet dsn process > 0x590 thread 0xa50 dbc 0x2c9389c jet'. (1); [01000] [microsoft][odbc > microsoft access driver]general warning unable open registry key > 'temporary (volatile) jet dsn process 0x590 thread 0xa50 dbc > 0x2c9389c jet'. (1); [hy024] [microsoft][odbc microsoft access driver] > '(unknown)' not valid path. create sure path name > spelled correctly , connected server on > file resides. (-1023)")

i can't see else on covers issue i'm new odbc , new so apologies if i've overlooked anything. have ideas?

cheers

python ms-access pyodbc parallels

No comments:

Post a Comment