I'm send a number of queries to an sql server, and getting results back, but nothing is returned by fetchall() or fetchone() for that matter. I know I'm getting good results back because I tcpdumped the traffic, and I can see query results coming back. I'm sure I'm missing something obvious. I'm running 1.0.2 with python 2.7.2, and tds 0.91. Could it be a freetds problem? I'm trying something simple:
I've tried without "as_dict", and still nothing. I've tried other queries, but still nothing. When I tcpdump the traffic, I see results coming back from the remote sql server, but nothing seems to come out of pymssql. What am I missing?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm send a number of queries to an sql server, and getting results back, but nothing is returned by fetchall() or fetchone() for that matter. I know I'm getting good results back because I tcpdumped the traffic, and I can see query results coming back. I'm sure I'm missing something obvious. I'm running 1.0.2 with python 2.7.2, and tds 0.91. Could it be a freetds problem? I'm trying something simple:
import pymssql
conn = pymssql.connect(host='remotehost.example.com', user='readonly', password='pass', database='db', as_dict=True)
cur = conn.cursor()
cur.execute('SET TEXTSIZE 65536;')
cur.execute("SELECT * FROM sys.tables;")
tables = cur.fetchall()
print tables
conn.close()
I've tried without "as_dict", and still nothing. I've tried other queries, but still nothing. When I tcpdump the traffic, I see results coming back from the remote sql server, but nothing seems to come out of pymssql. What am I missing?