i have a python project running with pyodbc, where I connect with a IBM i server.
When I want to connect with
connection = pyodbc.connect(
DRIVER='{iSeries Access ODBC Driver}',
SYSTEM='192.111.111.111',
UID='LUKESKYWALKER',
PWD='TATOOINE123')
cursor = connection.cursor()
I get
pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben (0) (SQLDriverConnect)')
Also when I want to try
print(pyodbc.drivers())
I get a empty list - I have tried to uninstall pyodbc and reinstall with Python packages in pycharm, but the error is still there