pymssql queries always return empty after upgrade to precise

[Brent Miller]

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)

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.