Board index » delphi » use 3rd party ADO component to return XML string instead of recordset

use 3rd party ADO component to return XML string instead of recordset

Hi,

Does anyone  know is there any 3rd party ADO component(free will be better)
that can return XML string (for SQL Server 2000 use "for xml auto" select) ?

Thanks in advance,
L.

 

Re:use 3rd party ADO component to return XML string instead of recordset


You need to do it using the XMLHTTPRequest object or any HTTP component you
may have...
You cannot with Recordsets. The format ADO wants is not compatible with the
one SQL 2k generates

Other Threads