Cannot make connection to .accdb file using python

Asked Mar 21 '18 at 10:17

Active Mar 21 '18 at 12:04

Viewed 434 times

I am writing a script that needs to make a connection to a microsoft access .accdb file and extract data from it.

Here is a snippet of what I am doing?

import pypyodbc
pypyodbc.lowercase = False

conn = pypyodbc.connect(
       r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};' +
       r'DBQ=file.accdb;'
       )
cur = conn.cursor()

I get the following error:

    raise Error(state,err_text)
pypyodbc.Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified')

I have installed the drivers for ODBC as instructed in https://learn.microsoft.com/en-us/sql/connect/python/pyodbc/step-1-configure-development-environment-for-pyodbc-python-development

But the error persists, any idea what should I do or where I am going wrong?

edited Mar 21 '18 at 12:04

Gord Thompson

116,920
32
215
418

asked Mar 21 '18 at 10:17

sshussain270

1,785
4
25
49

That link has instructions for connecting to SQL Server, not Access. The error message suggests that you working on a Windows machine. Is that correct? – Gord Thompson Mar 21 '18 at 12:01
@GordThompson That's correct! – sshussain270 Mar 21 '18 at 12:03
Do you have Microsoft Office installed on that machine? If so, is it the 32-bit version or the 64-bit version? – Gord Thompson Mar 21 '18 at 12:07
yes, and its 32 bit – sshussain270 Mar 21 '18 at 12:09
and my python is also 32-bit. – sshussain270 Mar 21 '18 at 12:09
You could try running [this script](https://github.com/gordthompson/AceOdbcCheck) to see if the ODBC driver is correctly configured for third-party applications. – Gord Thompson Mar 21 '18 at 12:17
It says your 64-bit setup is working properly, I had 32-bit before, I installed 64-bit when 32-bit didnt work. – sshussain270 Mar 21 '18 at 12:20
Try uninstalling the 64-bit driver and installing the 32-bit driver from [here](https://www.microsoft.com/en-US/download/details.aspx?id=13255). – Gord Thompson Mar 21 '18 at 12:31
@GordThompson No luck with this unfortunately :( – sshussain270 Mar 26 '18 at 09:56
Does the AceOdbcCheck script show different results now? – Gord Thompson Mar 26 '18 at 13:22
AceOdbcCheck script? – sshussain270 Mar 26 '18 at 13:23
The VBScript you ran earlier, link in a previous comment. – Gord Thompson Mar 26 '18 at 13:43
It says my 64-bit ODBC setup is working correctly. – sshussain270 Mar 26 '18 at 14:06

Cannot make connection to .accdb file using python

0 Answers0