Currently I am testing a few samples in Python from: Programming Microsoft® SQL Server™ 2000 with XML, Second Edition (http://www.microsoft.com/mspress/books/6137.asp) The following fragment (from chapter 6) does not work:
_conn = GenericUtil.CreateCOMObject('ADODB._connection') _conn._connectionString = "DATA PROVIDER=SQLOLEDB;SERVER=%s;Database=%s;Persist Security Info=False;User ID=%s;Password=%s" _conn.Provider = 'SQLXMLOLEDB.3.0' _conn.Open() _cmd = GenericUtil.CreateCOMObject('ADODB.Command') _cmd.Active_connection = _conn _cmd.Dialect = '{C8B522D7-5CF3-11CE-ADE5-00AA0044773D}' _outstr = GenericUtil.CreateCOMObject("ADODB.Stream") _outstr.Open() _cmd.Properties.Item('Output Stream').Value = _outstr _cmd.CommandText = "select * from test for xml auto" _cmd.Execute(Options = 1024) _outstr.Position = 0 print _outstr.ReadText(-1) Because COM is complaining about the output stream, which is supposted to be set in: _cmd.Properties.Item('Output Stream').Value = _outstr The same code in vbs does work. I am running winXP, ADO 2.8, python 2.3.4 _______________________________________________ Python-win32 mailing list [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/python-win32