** Also affects: pymssql (Ubuntu Xenial) Importance: Undecided Status: New
** Also affects: pymssql (Ubuntu Wily) Importance: Undecided Status: New ** Also affects: pymssql (Ubuntu Trusty) Importance: Undecided Status: New ** Also affects: pymssql (Ubuntu Precise) Importance: Undecided Status: New -- You received this bug notification because you are a member of नेपाली भाषा समायोजकहरुको समूह, which is subscribed to Xenial. Matching subscriptions: Ubuntu 16.04 Bugs https://bugs.launchpad.net/bugs/918896 Title: No data returned from MSSQL server Status in pymssql package in Ubuntu: Confirmed Status in pymssql source package in Precise: New Status in pymssql source package in Trusty: New Status in pymssql source package in Wily: New Status in pymssql source package in Xenial: New Status in pymssql source package in Yakkety: Confirmed Status in pymssql package in Debian: New Bug description: [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) To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pymssql/+bug/918896/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~group.of.nepali.translators Post to : group.of.nepali.translators@lists.launchpad.net Unsubscribe : https://launchpad.net/~group.of.nepali.translators More help : https://help.launchpad.net/ListHelp