RE: Retrieve XML data from SQL 2000

[Michael Rys <mrys@microsoft.com>]

Use the built-in XML support (either FOR XML queries or XPath queries
against annotated schema). Books Online contains examples on how to use
ADO 2.6 with the XML support.

Best regards
Michael

> -----Original Message-----
> From: Marcos A. Sanchez Rodriguez [mailto:marcos@discoweb.com] 
> Sent: Friday, July 13, 2001 3:38 AM
> To: xml-dev@lists.xml.org
> Subject: Retrieve XML data from SQL 2000
> 
> 
> I need to retrieve XML data from a Microsoft SQL 2000 
> database with ADO 2.6. The tables can contains non XML valid 
> character like "&" or "<". How can I do this?
> 
> Thanks in advance.
> 
> 
> 
> ------------------------------------------------------------------
> The xml-dev list is sponsored by XML.org, an initiative of 
> OASIS <http://www.oasis-open.org>
> 
> The list archives are at 
> http://lists.xml.org/archives/xml-dev/
> 
> To unsubscribe from this elist send a message with the single 
> word "unsubscribe" in the body to: xml-dev-request@lists.xml.org
>