[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