pymssql connection does not return data and only prints the colum name?

Question

I'm trying to fetch the data from server so I tried as follow

#!/usr/bin/python
import pymssql
conn = pymssql.connect(host='xxxx', user='xxx', password='xxx', database='xxx')


cursor = conn.cursor()
x2 = 'select * from result where url like\'%get content%\''
cursor.execute(x2)
data = cursor.fetchall()
field_names = [i[0] for i in cursor.description]
print field_names
print data

When I run this program it only give the column name, data variable is empty. I don't know what is the reason. How can I fix it?

I'm running the same script in windows there is no problem. But when I execute the script in Ubuntu 14.04 the data variable is empty.

Can you check cursor.rowcount after or before fetchall() command. — Harsha Biyani
– Harsha Biyani, Commented Jan 10, 2017 at 12:45
Is it giving -1 in both cases (before & after fetchall)? If yes, then there is problem query or connection.. — Harsha Biyani
– Harsha Biyani, Commented Jan 10, 2017 at 12:49
@HarshaBiyani Yes both cases it's result -1. If query or connection is problem mean how the column gets print? — mkHun
– mkHun, Commented Jan 10, 2017 at 12:52
ohh correct.. Have you tried with simple query? like - select * from result? — Harsha Biyani
– Harsha Biyani, Commented Jan 10, 2017 at 12:56

Omid · Accepted Answer · 2017-01-13 14:30:42Z

4

+50

This is a known bug of PyMSSQL 1.0.x on Ubuntu. See No data returned from MSSQL server. Solution is to upgrade it to version >= 2.0.1.

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.

Thomas Ward (teward) wrote on 2016-06-05:

This is due to an incompatibility between freetdx and PyMSSQL 1.0.x.

Workaround is to remove the python-pymssql package, and run pip install pymssql or easy_install --upgrade pymssql or similar, to get the most up to date pymssql version, greater than or equal to 2.0.1.

ALso confirmed this issue on Xenial and Yakkety, as well as Trusty.

edited Jan 13, 2017 at 14:30

answered Jan 13, 2017 at 10:27

Omid

6,1534 gold badges45 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

vatay · Accepted Answer · 2017-01-13 12:03:26Z

-1

You can try pyodbc on ubuntu 14.04

answered Jan 13, 2017 at 12:03

vatay

3872 silver badges9 bronze badges

Collectives™ on Stack Overflow

pymssql connection does not return data and only prints the colum name?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related