0

I wrote a Python test script that should read data from the Microsoft Access database, but I get an error message.

import pyodbc


conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Users\serge\PycharmProjects\TestPyOdbc\CustomerGasketData.mdb;')
cursor = conn.cursor()
cursor.execute('select * from dichtungen')

for row in cursor.fetchall():
    print(row)

Error message:

C:\Users\serge\AppData\Local\Programs\Python\Python38\python.exe C:/Users/serge/PycharmProjects/TestPyOdbc/main.py
Traceback (most recent call last):
  File "C:/Users/serge/PycharmProjects/TestPyOdbc/main.py", line 4, in <module>
    conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Users\serge\PycharmProjects\TestPyOdbc\CustomerGasketData.mdb;')
pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben (0) (SQLDriverConnect)')

Process finished with exit code 1

I checked which ODBC drivers are available at all in Python:

enter image description here

there is no Microsoft Access Driver (* .mdb, * .accdb) in this list, but the drivers are installed on the PC.

enter image description here

What do I need to do to make Microsoft Access Driver (* .mdb, * .accdb) available in Python?

Sergej_S
  • 11
  • 2

0 Answers0