** Description changed:
+ [Impact]
+
+ * Due to an issue with PyMSSQL 1.0.x and the version of FreeTDX in the
+ repositories, PyMSSQL no longer returns any information from MSSQL
+ database queries. This means you cannot use fetchone() or fetchall() or
+ similar methods to get data back from a database query.
+
+ [Test Case]
+
+ * Install python-pymssql to Ubuntu.
+
+ * Inside a 'python' console on the Ubuntu server, use the following python
code, replacing values accordingly for your MSSQL servers. The "print"
function will return 'None' in the current code base. When fixed, you will get
either one value, or a tuple, depending on the results (but you will NOT get
'None'):
+
+ import pymssql
+ dbconn = pymssql.connect(host='FQDN_FOR_DBSERVER', user='DBUSER',
password='DBPASSWORD', database='DBNAME')
+ dbcur = dbconn.cursor()
+ dbcur.execute('ANY_VALID_SQL_QUERY')
+ dbrs = dbcur.fetchone()
+ dbcur.close()
+ print dbrs
+
+
+ [Regression Potential]
+
+ * The patch in the debdiffs is from pymssql upstream. We are on a very
+ old pymssql, but this patch was designed to fix the issue.
+
+
+ [Other Info]
+
+ * Test builds in
https://launchpad.net/~teward/+archive/ubuntu/pymssql/+packages; these packages
in that PPA are used for testing and were used to test the upstream patch.
+
+
+ [Original Description]
+
this works great in oneiric, but in precise it silently returns empty results
from SQL server. The upstream project has relocated and provided a new release,
I downloaded and built it and the same code I had started returning results.
http://code.google.com/p/pymssql/downloads/list
ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: python-pymssql 1.0.2+dfsg-1build1
ProcVersionSignature: Ubuntu 3.2.0-9.16-generic 3.2.1
Uname: Linux 3.2.0-9-generic x86_64
ApportVersion: 1.91-0ubuntu1
Architecture: amd64
Date: Thu Jan 19 20:24:31 2012
EcryptfsInUse: Yes
InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Release amd64 (20101007)
SourcePackage: pymssql
UpgradeStatus: Upgraded to precise on 2012-01-16 (2 days ago)
** Tags added: trusty wily xenial yakkety
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/918896
Title:
No data returned from MSSQL server
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/pymssql/+bug/918896/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
