Blank results using mxODBC against

[Steve Holden]

"Sandeep Gupta" <sandeep182 at hotmail.com> 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
columns
> 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.

regards
-----------------------------------------------------------------------
Steve Holden                                 http://www.holdenweb.com/
Python Web Programming                http://pydish.holdenweb.com/pwp/
-----------------------------------------------------------------------