Re: MDAC Converting Dataset to XML

Stewart (Oraculum) wrote:
The "recordset" is a pointer to an already open recordset passed into
the function that does the conversion to XML. The XML is then passed
to a separate function to convert back to a recordset (mimicking the
multi-tier nature of the application).

<snip>
Note, the line "ADODataSet1.Recordset := _RecordSet(IUnknown(RS));"
demonstrates on screen that a valid recordset has been read from
plain XML, this didn't involve access to the database. Both the
output XML and the data grid containing the results show the invalid
data.


Ok, we now have a valid repro that removes the database and its provider
from the equation. Now we need to verify that upgrading MDAC fails to
eliminate the symptom. Is that possible for you to do?
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: How to Programmatically Export as XML & SXL
    ... Unfortunately, I've had precious little to do with XML in Access, so I'm ... you use the ADO Recordset object's Save ... >>Dim rs As ADODB.Recordset ... >>Dim strADTGFile As String ...
    (microsoft.public.access.externaldata)
  • Re: MDAC Converting Dataset to XML
    ... I hadn't realised there was a later version of MDAC than the one we had ... recordset is fine, the code that does this is a mirror of the conversion to ... XML and for completeness I include a copy (albeit ... Can you reproduce the symptom by saving the first piece of xml to a file, ...
    (microsoft.public.data.ado)
  • Re: Classic ASP to .NET WebService interfacing (Dataset to RecordSet)
    ... webservice when connecting to linux based servers. ... > recordset and stream it to XML which can be returned but ... ... > Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Database + dll
    ... You can include an XML or ADTG persisted Recordset with the ... XML can be compiled into a DLL as a resource, ... copied to a stream first anyway (not that the recordset would alter the ... It's a simple matter of creating a custom resource type from an XML file at ...
    (microsoft.public.vb.database.ado)
  • Re: XSD to Pascal Objects?
    ... > we're talking about a very niche, specific market. ... > be too simple to justify a high price or else no one would buy it. ... > another, nested recordset. ... > an XML file, it saves all the child recordsets too. ...
    (borland.public.delphi.thirdpartytools.general)