Cannot connect to Access DB using pyodbc

Question

I've been beating my head against this for a few days now. I'm trying to use pyodbc to connect to a Microsoft Access DB, and I can't seem to get the connection string right or something. This is what I'm using:

cnxn = pyodbc.connect(r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Path\to\file.accdb')

I keep getting the error:

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

Even though when I run dataSources() I see:

{'MS Access Database': 'Microsoft Access Driver (*.mdb, *.accdb)', 'dBASE Files': 'Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)', 'Excel Files': 'Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)'}

Is there something I'm severely missing here?

There is a similar question that may help : stackoverflow.com/questions/3251702/… — Fionnuala
– Fionnuala, Commented Dec 28, 2010 at 20:08
I'd already found that thread and tried all that it suggests. Still can't seem to get this to work. — dciliske
– dciliske, Commented Dec 28, 2010 at 20:34
It's helpful when you post a question after trying other SO solutions to point to them and explain why they didn't solve your problem. — David-W-Fenton
– David-W-Fenton, Commented Dec 29, 2010 at 1:49

eowoyn · Accepted Answer · 2011-11-09 00:09:56Z

6

This is a 64-bitness problem. I solved it by using 32-bits python and pyodbc.

answered Nov 9, 2011 at 0:09

eowoyn

761 silver badge2 bronze badges

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

Comments

mwolfe02 · Accepted Answer · 2010-12-28 21:22:01Z

1

Try adding Provider=MSDASQL. It's deprecated but it seems to work OK:

cnxn = pyodbc.connect(r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};
DBQ=C:\Path\to\file.accdb; Provider=MSDASQL;')

answered Dec 28, 2010 at 21:22

mwolfe02

24.3k10 gold badges102 silver badges174 bronze badges

6 Comments

dciliske Over a year ago

Tried it. Doesn't work. Am I really missing something? I'm running Windows 7 Professional with Access 2007

mwolfe02 Over a year ago

It worked for me with Access XP (2002) connecting to an .mdb on Windows 7 Professional. Since it is deprecated maybe it doesn't support the new .accdb format.

mwolfe02 Over a year ago

It also worked for me with Access 2007 connecting to an .accdb on Windows XP Professional. I don't have a Win7 machine with Access 2007 installed, so I can't replicate your environment.

dciliske Over a year ago

ok, I am really mystified now... Everything I try always gives me the same error string.

Jack_of_All_Trades Over a year ago

@SwimmingCode Do you have some solution to this question you posted without resorting on using 32-bit python and pyodbc? I am running exactly into the same problem.

|

Collectives™ on Stack Overflow

Cannot connect to Access DB using pyodbc

2 Answers 2

Comments

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related