Blank results using mxODBC against

Steve Holden sholden at
Wed Jun 26 11:49:59 EDT 2002

"Sandeep Gupta" <sandeep182 at> wrote ...
> We are trying to connect to MS SQL Server from Linux, but we are only
> receiving blank values in the query results.  The number of rows and
> in the result is correct, but each result cell is blank.
> As a test, we successfully used mxODBC against a local MySQL going through
> unixODBC.
> We then tried: Python2.2 --> mxODBC --> unixODBC --> inline TDS 1.6 --> MS
> SQL Server
> When I use isql with unixODBC, I am able to view the results of a simple
> select.  That same select in mxODBC returns blank result values.
> The python code I'm using is:
> import mx.ODBC.unixODBC
> db = mx.ODBC.unixODBC.DriverConnect('DSN=MSSQL')
> c = db.cursor()
> c.execute('select * from dbo.Source;')
> mx.ODBC.print_resultset(c)
[other information]

Try running the mxODBC test program on the data source you are expecting to
use, ands see if it returns any errors.

Steve Holden                       
Python Web Programming      

More information about the Python-list mailing list