DLL & COM & ActiveX: Xml

• damo / 104 / Wed, 18 Nov 2009 01:18:00 GMT / Comments (4)
• Someone knows (or can give me an example) how to pass a recordset between two tiers (DLLs) using XML. I did it but using ADO Recordsets, and the problem is that I have to have installed ADO in both machines.
  Thanks so much for your coments.
• Keywords:

  xml, dll, com, activex

• http://programming.itags.org/com-activex/174575/«« Last Thread - Next Thread »»

• 1. You can
     a - pass it as a XML obj (using MS XML parser) or stream
     
     or
     
     b - pass it as a string
     
     I guess the question is how the receiving end is gonna process the info, since if you use option
     
     a - then you will need a XML parser on the other end
     b - you will need to parse the string your self (code and code and more code)
     
     But If you want to see more about the option 'a', I'll dig in to my archives, and try to come up with a sample.

     demirc | Wed, 05 Dec 2007 13:35:00 GMT |

  2. Just use MSXML parser. All you have to do is load it into a DOM object, and traverse the tree structure from there. MSXML object hiearchy is pretty easy to manipulate and if you need any help, just give a shout back.

     lethal | Wed, 05 Dec 2007 13:36:00 GMT |

  3. Thank you so much for your help. Do you know where I can find an example. I have installed the XML parser and I saw an example of how to read it, but it will be nice to manipulate a Recordset between tiers and send the information as XML. Thanks again.

     damo | Wed, 05 Dec 2007 13:37:00 GMT |

  4. Dim adoRS AS New ADODB.Recordset
     Dim adoStr AS New ADODB.Stream
     Dim objXML AS New MSXML2.DOMDocument
     
     'Get your Recordset however
     
     'Save it to the stream object
     Call adoRS.Save(adoStr, adPersistXML)
     
     'Now you have the XML extracted from the recordset
     'and placed in the stream object
     
     Debug.Print adoStr.ReadAll
     
     'You can just pass that as a string or load it into a XML
     'DOM Document
     
     objXML.loadXML(adoStr.ReadAll)
     
     'Now you can pass the whole object and the XML has
     'been parsed into objects for you

     waldo | Wed, 05 Dec 2007 13:38:00 GMT |