#!/usr/bin/env python
import _mssql
conn=_mssql.connect(server='server',user='test',password='password',database='test')
conn.execute_query("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS")
for row in conn:
print row
if it is working it should return a bunch of data about columns, in precise it just returns nothing.
trivial python to show the problem
#!/usr/bin/env python connect( server= 'server' ,user=' test',password= 'password' ,database= 'test') query(" SELECT COLUMN_NAME FROM INFORMATION_ SCHEMA. COLUMNS" )
import _mssql
conn=_mssql.
conn.execute_
for row in conn:
print row
if it is working it should return a bunch of data about columns, in precise it just returns nothing.