Hi James,

Please consider the following code that retrieves an XML document from SQL Server 2000 through HTTP (by the configuration of the IIS virtual directory and SQLXML Wev release). It uses the XMLHTTP class from MSXML library.

LOCAL loXMLHTTP as "MSXML2.XMLHTTP"

loXMLHTTP = CREATEOBJECT("MSXML2.XMLHTTP")
loXMLHTTP.open("GET", ;
               "http://localhost/sql?sql=select+*+from+Customers+for+xml+auto&root=Teste", ;
               .F.)
loXMLHTTP.send()

MESSAGEBOX(loXMLHTTP.responseXML.Xml)

loXMLHTTP = null
               

HTH