ADO \ ADO.Net

15 Feb 2006 1:51 PM

DylanM

Hi,

We have an old web service that's written in VB6. It expects an XML document
that it can load into an ADODB recordset as follows...

set objADORst = Server.CreateObject("ADODB.Recordset.2.7")
set objXML = Server.CreateObject("Msxml2.DOMDocument.3.0")
Set objEDIMain = Server.CreateObject("EDIGenerator.EDI")

objXML.async = false
if objXML.load(Request) then
    objADORst.Open objxml
Else
    Response.Write "1|Error Loading Recordset in Webservice"
    Response.End
End If

We have programs that call this using VB6 code as follows...

    With objAdoRst
        .MoveFirst
        Call .Save(objXMLDOM, adPersistXML)
    End With

    With objXMLHTTP
        Call .Open("POST", sServiceHTTP)
        Call .Send(objXMLDOM)
        sResponse = .responseText
    End With

I need to do that same thing for a client written in c#, the service is
staying as it is. Will the service be able to create an ADODB recordset from
XML data that has been constructed from a DataSet? eg;

DataSet data = sql.ExecuteDataSet(pcData);
xmlFile = WriteXmlToFile(data);
response = PostData(xmlFile);

Thanks

15 Feb 2006 3:21 PM

DylanM

Ah - I see the XDR schema that ADODB.Recordset.Save function created is now
completely obsolete, so probably better if we rewrite the service to the new
schema & update all the older clients.