search

mkleehammer / pyodbc

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

Jupyter Kernel Dies when trying to connect to PSQL 12.10 database. It works fine when executing python script via Anaconda terminal #1092

Closed agopichand88 closed 1 year ago

agopichand88 commented 1 year ago

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

Jupyter Kernel dies on running pyodbc.connect statement,, but when executing the script via Anaconda terminal returns output without any issues. This only happens with this Driver.

Pervasive ODBC Interface, tested fine and able to connect to it using Excel without any issues.

v-makouz commented 1 year ago

Does it print any errors?

agopichand88 commented 1 year ago

Nope, it just does after a couple of secs.

gordthompson commented 1 year ago

An ODBC trace for the failing case might provide some insight.

agopichand88 commented 1 year ago

It doesn't generate any odbc trace file while running through Jupyter Notebook.