All,

I am getting an error on oRecordset.Open oDOMDocumentResult

The error is "Recordset cannot be created. Source XML is incorrect or invalid."

Does anyone know of any XML converter for me to be able to create the recordset? I can only change the VB6 code as i cannot alter the webservice.

Thanks
G

Dim oSoapClient As MSSOAPLib30.SoapClient30
Dim oIXMLDOMNodeListResult As MSXML2.IXMLDOMNodeList

Set oSoapClient = New SoapClient30

Dim oDOMDocumentResult As MSXML2.DOMDocument

oSoapClient.MSSoapInit "http://servername:81/PSIProxy/WebservicePage.asmx?WSDL", "WebserviceName"

Set oIXMLDOMNodeListResult = oSoapClient.WebserviceMethod("TESTACT", "TESTPARM")

oDOMDocumentResult.LoadXml oIXMLDOMNodeListResult.Item(1).xml

Set objNodeList = oDOMDocumentResult.selectNodes("//NewDataSet/Table/ACTIVITY_ID/text()")

Set oRecordset = New ADODB.Recordset
oRecordset.Open oDOMDocumentResult

Sorry for info the xml that is being passed to oRecordset.Open is:

<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1"><NewDataSet xmlns=""><Table diffgr:id="Table1" msdata:rowOrder="0"><ACTIVITY_ID>001</ACTIVITY_ID></Table><Table diffgr:id="Table2" msdata:rowOrder="1"><ACTIVITY_ID>70F</ACTIVITY_ID></Table><Table diffgr:id="Table3" msdata:rowOrder="2"><ACTIVITY_ID>70M</ACTIVITY_ID></Table><Table diffgr:id="Table4" msdata:rowOrder="3"><ACTIVITY_ID>70X</ACTIVITY_ID></Table><Table diffgr:id="Table5" msdata:rowOrder="4"><ACTIVITY_ID>C11</ACTIVITY_ID></Table><Table diffgr:id="Table6" msdata:rowOrder="5"><ACTIVITY_ID>K18</ACTIVITY_ID></Table><Table diffgr:id="Table7" msdata:rowOrder="6"><ACTIVITY_ID>L12</ACTIVITY_ID></Table><Table diffgr:id="Table8" msdata:rowOrder="7"><ACTIVITY_ID>L13</ACTIVITY_ID></Table><Table diffgr:id="Table9" msdata:rowOrder="8"><ACTIVITY_ID>L14</ACTIVITY_ID></Table><Table diffgr:id="Table10" msdata:rowOrder="9"><ACTIVITY_ID>L21</ACTIVITY_ID></Table><Table diffgr:id="Table11" msdata:rowOrder="10"><ACTIVITY_ID>L22</ACTIVITY_ID></Table><Table diffgr:id="Table12" msdata:rowOrder="11"><ACTIVITY_ID>L58</ACTIVITY_ID></Table><Table diffgr:id="Table13" msdata:rowOrder="12"><ACTIVITY_ID>M32</ACTIVITY_ID></Table><Table diffgr:id="Table14" msdata:rowOrder="13"><ACTIVITY_ID>M35</ACTIVITY_ID></Table></NewDataSet></diffgr:diffgram>

how to access Vb.6 function from C# web service? http://www.codingcabinet.com/questio...c-web-service/