ADO \ ADO.Net

[Guest]

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

 

[Guest]

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.