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.


** Attachment added: "check_mssql_sqlalchemy.zip"
   
https://bugs.launchpad.net/ubuntu/+source/freetds/+bug/887374/+attachment/3156064/+files/check_mssql_sqlalchemy.zip

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/887374

Title:
  Update to a newer FreeTDS

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/freetds/+bug/887374/+subscriptions

-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to