Issue 207: pyodbc x64 with 32bit office
Status:  Complete
Owner: ----
Closed:  Oct 2011
Reported by jonathan...@gmail.com, Sep 1, 2011
What steps will reproduce the problem?
1.Cannot connect to msaccess 2007 database using this string:
"Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\\schema.accdb"
2.I receive this error:
pyodbc.Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source na
me not found and no default driver specified (0) (SQLDriverConnectW)')
3.I use the pyodbc.drivers() commands to enumerate my drivers, the only driver there is 'SQL Server', how do I get 'Microsoft Access Driver' to be recognized by pyodbc?  I have installed the Office System Driver: http://www.microsoft.com/download/en/confirmation.aspx?id=23734

What is the expected output? What do you see instead?


What version of the product are you using? On what operating system?
Windows 7 64bit with pyodbc-2.1.9.win-amd64 and python2.7 64 bit

Please provide any additional information below.
I think this might have something to do with the fact that I am running 32bit office on Win7 64bit with 64 bit python and pyodbc?

Please Help!

Oct 16, 2011
Project Member #1 mkleehammer
You need the 64-bit ODBC driver, regardless of the "bitness" of office.

I'm going to close this, because I think that's the answer.  If not, your best bet is to post to the pyodbc group so more people can help us.

Status: Complete