[egenix-users] SQL Server query result as XML

Jim Vickroy Jim.Vickroy at noaa.gov
Wed Feb 19 11:07:19 CET 2003


Hello,

I'm using mx.ODBC.Windows with Python 2.2.2 on a Windows 2000 machine.

Here is the result of asking SQL Server to formulate a query result as
XML:

>>> cur.execute('select * from employee for xml auto')
Traceback (most recent call last):
  File "<interactive input>", line 1, in ?
Warning: ('01004', 0, '[Microsoft][ODBC SQL Server Driver]String data,
right truncation', 2394)


The above SQL query works fine from MS SQL QueryAnalyzer.

Any ideas why it does not work from Python?

Thanks,

-- jv



More information about the egenix-users mailing list