Comment 3 for bug 918896

Revision history for this message
Fred (rischfre) wrote : Re: returns no data from SQL server

Have got the same issue, code working properly on 11.04 but no way to get it work on 12.04

#!/usr/bin/env python

import _mssql

conn = _mssql.connect(server='192.168.1.xxx:1433', user='linux', password='linux', database='MYDB')
result = conn.execute_scalar("SELECT MediaLabel FROM T_MediaStatus")
print result

conn.close()