Ubuntu
freetds package

  1. Bug #887374
  2. Comment #5

Comment 5 for bug 887374

Revision history for this message
Wolfgang Scherer (wolfgang-scherer) wrote :

While it is nice to have a more recent version of FreeTDS, it does break the very OLD python-pymssql and python-pyodbc packages.

python-pymssql (1.0.2+dfsg-1build1)
python-pyodbc (2.1.7-1build2)

python-pyodbc struggles with unicode decoding problems (TDS_Version = 8.0).
TDS_Version = 9.0 delivers correct query results but sqlalchemy will then try to use unavailable features, like sys.indexes, on MSSQL Server 2000/2005.

sqlalchemy fails silently with `mssql+pyodbc://`, which is worse than failing with an error.

python-mssql can no longer make a connection and sqlalchemy `mssql+pymssql://` fails with an error.

The attached script checks FreeTDS/pyodbc/pymssql/sqlalchemy.

The logs for oneiric and precise-fixed (with pymssql + pyodbc installed via easy_install) show the correct results.

The log for precise with system packages python-pymssql and python-pyodbc show the failures.