ODBC SQL connection error from command line but not from IDLE

[ghost]

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