pymssql can connect but does not return any results

Question

I am connecting to an MS SQL server with pymssql. I can connect by tsql -H ip -p 1433 -U xx - p xx and by jupyter notebook. The connection does not return any errors.

However, I tried many queries with pymssql but none of them returned results.

For example, cursor.execute('SELECT * FROM INFORMATION_SCHEMA.TABLES ')

What should I check now?

execute query just executes the query you need to fetch records to display them. Please check for cursor.fetchone :) — Ranjana Ghimire, Nov 10 '16 at 04:07
@RanjanaGhimire `cursor.fetchone` returns the database info. Thanks. — Jill Clover, Nov 10 '16 at 04:20

score 0 · Accepted Answer · answered Nov 11 '16 at 00:47

As mentioned in the "Iterating through results" section of the pymssql examples, you can simply iterate through the rows of the result set like this:

crsr = conn.cursor()
crsr.execute("SELECT * FROM INFORMATION_SCHEMA.TABLES")
for row in crsr:
    print(row)

Or, to use a more standard DB-API approach:

crsr = conn.cursor()
crsr.execute("SELECT * FROM INFORMATION_SCHEMA.TABLES")
for row in crsr.fetchall():
    print(row)

pymssql can connect but does not return any results

1 Answers1