My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 207: pyodbc x64 with 32bit office
1 person starred this issue and may be notified of changes. Back to list
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

Powered by Google Project Hosting