Geek Answers Handbook

"Data source name not found, but no default driver specified" with Access ODBC

My programs:

  • Python 3.4 -64 bit
  • PyODBC 64 bit
  • MS office package Installed (32 bit)

Problem:

Now I am trying to access MS Access 2010 installed on my computer using PYODBC. This does not work no matter what I try. My mistake is always this:

pyodbc.Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')

I already looked:

pyopbc and ms access 2010 connection error

Cannot connect to access database using pyopbc

This is supposed to be a problem with 32-64 bits, and I am sure that it is. Is there any modification that can be made to make it work without installing 32-bit python and 32-bit pyodbc? I checked this website. Using ODBC (32-bit and 64-bit) on 64-bit Windows , which explains access to the control panel to change ODBC and / or drivers. However, I don’t know much about internal connections to Windows databases to start some changes.

Is there anything I can do to make it work?

+7
python ms-access odbc pyodbc
source share
1 answer

Is there any modification that can be made to make it work without installing 32-bit python and 32-bit pyodbc?

Not really. If you have 32-bit Office installed, you have a 32-bit version of the Database Database Engine (aka "ACE"), and only 32-bit applications can use it.

The installer for the 64-bit version of the Database Database Engine will fail if it detects 32-bit Office components. There is a way to get the installer to continue, but this is not recommended, as it may seem to break Office.

Bottom Line: The "bitness" of your application must match the "bitness" of the installed Database Database Engine. So, actually, your options

  • Use 32-bit Python and pyobbc, or
  • Replace 32-bit Office with 64-bit.
+6
source share

More articles:


All Articles