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:
there is no Microsoft Access Driver (* .mdb, * .accdb) in this list, but the drivers are installed on the PC.
What do I need to do to make Microsoft Access Driver (* .mdb, * .accdb) available in Python?