Connect to Access 2013 with Python: Data source name not found

Question

I use this code to connect to Access 2013:

conn_str = r"Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\_DELOITTE\Statistics.mdb;"
self.conn = pyodbc.connect(conn_str)

I get the following error:

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

I use Windows 8, Intel processor, 32-bit Access, and Python 2.7.

In Administrative Tools I have ODBC Data Sources (32-bit) and ODBC Data Sources (64-bit) both pointing at %windir%\system32\odbcad32.exe. Only "System DSN" is filled in, but no "User DSN".

disflux · Accepted Answer · 2015-12-30 15:58:10Z

4

This could be incompatibility if you are using 64bit Python. I just tested something similar on my machine.

This isn't conclusive since these are different versions of Python, but it is a lead to follow. Here's what I tested:

32bit Python 2.7, on a 32bit MS Access driver. Connection successful, no errors.

64bit Python 3.4, on a 32bit MS Access driver. Returned Error: "pyodbc.Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source na me not found and no default driver specified (0) (SQLDriverConnect)')"

edited Dec 30, 2015 at 15:58

answered Dec 30, 2015 at 15:40

disflux

4393 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Mad Physicist Over a year ago

This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post - you can always comment on your own posts, and once you have sufficient reputation you will be able to comment on any post. - From Review

disflux Over a year ago

Actually. It can provide an answer to the question, if the OP is using 64bit Python. Given that I cannot comment on the OP's question (due to lack of rep), how else am I to determine if the OP is using a 64bit or 32bit Python?

Mad Physicist Over a year ago

Get more rep or use chat.

disflux Over a year ago

It is only your opinion that this is not an answer, however, this is a plausible solution to the problem that the OP is having, with potential evidence of its effect. If, for some reason, the OP comes back and determines that this is not a plausible solution, I will of course delete it.

Ekaterina Ermilova Over a year ago

Yes, I use Python 64-bit! I will try to get Python 32-bit and ee if the connection works.

|

Collectives™ on Stack Overflow

Connect to Access 2013 with Python: Data source name not found

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related