Bobspadger / pyodbc

Automatically exported from code.google.com/p/pyodbc
MIT No Attribution
0 stars 0 forks source link

pyodbc x64 with 32bit office #207

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
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!

Original issue reported on code.google.com by jonathan...@gmail.com on 1 Sep 2011 at 4:47

GoogleCodeExporter commented 9 years ago
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.

Original comment by mkleehammer on 16 Oct 2011 at 12:48