blue-yonder / turbodbc

Turbodbc is a Python module to access relational databases via the Open Database Connectivity (ODBC) interface. The module complies with the Python Database API Specification 2.0.
http://turbodbc.readthedocs.io/en/latest
MIT License
616 stars 86 forks source link

ODBC SQL connection error from command line but not from IDLE #346

Open ghost opened 2 years ago

ghost commented 2 years ago

I'm using a Python script that utilizes Turbodbc to connect to MS SQL. If the script is run inside IDLE it works fine. If it is executed from the Windows command line it reports SQL connection errors. Having tested various Python virtual environments my conclusions are that there is something significantly different about the IDLE execution environment as opposed to command line that is causing this issue.

Can anyone please shed any light on the differences between IDLE and command line so I can determine what the missing piece of the puzzle is? Thx Dave