mkleehammer / pyodbc

Python ODBC bridge
https://github.com/mkleehammer/pyodbc/wiki
MIT No Attribution
2.92k stars 561 forks source link

pyodbc.drivers() get empty array inside jupyter container #1048

Closed b-y-f closed 2 years ago

b-y-f commented 2 years ago

Please first make sure you have looked at:

Environment

To diagnose, we usually need to know the following, including version numbers. On Windows, be sure to specify 32-bit Python or 64-bit:

Issue

Im using this notebook and tried to connect with remote MSSQL server, and ok with pip install pyodbc. But cannot connect to database and pyodbc.drivers() shows me empty [ ]

gordthompson commented 2 years ago

Have you installed the ODBC driver for SQL Server as described here?

b-y-f commented 2 years ago

Not sure, but in for other project in js with the help of mssql, we can connect to db without any issue.

v-chojas commented 2 years ago

Python is not JavaScript, and pyODBC is a generic ODBC interface. Please read the documentation.

b-y-f commented 2 years ago

I see. Thank you guys! 👍