pyodbc.drivers() = []?

32 views Asked by At

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

0

There are 0 answers