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

Reply via email to