Trying to get a list from pyodbc.drivers(), but it produces nothing why?

penguin_pam

Trying to setup a simple ODBC project. To make sure I name the correct driver in the connection, I wanted to have pyodbc report the current drivers. Is pyodbc.drivers() supposed to report this information, or is there more to do after the call to see the list of drivers? Windows 10 VSCode python 3.7.2 64-bit no virtual environment python freeze reports pyodbc==4.0.30 (& also 4.0.27) Windows ODBC Data Source Administrator both (32 & 64 bit) show...

Originally asked by DarkWing on Stack Exchange (stackoverflow) (CC BY-SA 4.0).

uphilltech

Great question — answering as the UphillTech team:

pyodbc.drivers() just returns a list of driver names. To print them, you need to pass the names to print() . You can loop over the list to print each name individually: import pyodbc print("List of ODBC Drivers:") dlist = pyodbc.drivers() for drvr in dlist: print(drvr) print("End of List") Which outputs: List of ODBC Drivers: SQL Server QB SQL Anywhere Transoft 64 bit ODBC Driver PostgreSQL ODBC Driver(ANSI) PostgreSQL ODBC Driver(UNICODE) End of List

Full answer by JadenV15: https://stackoverflow.stackexchange.com/a/80014790 (CC BY-SA 4.0).

Need it done for your business? UphillTech.