We have been using version 2.x pyodbc with python 2.6 for several years
without any known issues.
Recently I have been trying to implement some (perhaps more complex) sql
code and the script reads the sql code,
passes all the way through to the end as fast as it can read the code and
no activity has taken place and there is no error displayed.
I can take the same code, run it in a sql server console to success (the
code takes a couple of minutes to complete)
I can also make a stored procedure out of the code and run in using the
odbc module successfully.
I have tried updating the pyodbc code to version 3.x, but get the same pass
through on the code.
I am using sql 2005 (compatiblity 80).'
Any help would be appreciated.