Public bug reported: This module used to work fine under oneric (and it appears to be the exact same version in precise) but after upgrading, all queries will return zero results. So far I've tested this sample script against two machines running precise amd64 and one running oneric. Running on oneric always returns the expected result while both machines running precise will return an empty list.
import pymssql conn = pymssql.connect(host = "*", user = "*", password = "*", database = "*") cur = conn.cursor() cur.execute("""select top 10 * from <TABLENAME>""") print cur.fetchall() cur.close() conn.close() Additionally, if I open up wireshark and monitor the queries on the precise machines, I can see the request go out and the response come back, but the script will always return an empty list. I'm querying MS SQL Server 2008 10.00.1600 ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: python-pymssql 1.0.2+dfsg-1build1 ProcVersionSignature: Ubuntu 3.2.0-24.37-generic 3.2.14 Uname: Linux 3.2.0-24-generic x86_64 ApportVersion: 2.0.1-0ubuntu7 Architecture: amd64 Date: Thu May 10 16:35:52 2012 EcryptfsInUse: Yes InstallationMedia: Ubuntu 11.04 "Natty Narwhal" - Release amd64 (20110427.1) SourcePackage: pymssql UpgradeStatus: Upgraded to precise on 2012-04-30 (10 days ago) ** Affects: pymssql (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apport-bug precise -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/997853 Title: pymssql queries always return empty after upgrade to precise To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pymssql/+bug/997853/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs