Re: Trouble recreating ADO recordset from XML

Hi,

Sorry - hope this clarifies.

I use rst->Save to persist the data into a _Stream object. I then
send the stream over COM.

On the other side, I take the stream received, and use
_Stream::WriteText in order to take the buffer received over COM and
write it into the new stream.

Finally, I use Recordset::Open with the stream, an empty connection
(retrieved from the GetActiveConnection method of the recordset
pointer, which should be an empty connection), adOpenDynamic for
cursor type, adLockbatchOptimistic for the lock tyoe, and adCmdFile as
an option.

This works on most machines, but doesn't on a certain group.

The exception I get when trying to look in the recordset has no
description (the string seems to be empty), and the HRESULT is S_OK,
making debugging this all the more difficult.

Thanks,
Eyal

.

Relevant Pages

  • Re: Trouble recreating ADO recordset from XML
    ... and a source for the Open function. ... I use rst->Save to persist the data into a _Stream object. ... Finally, I use Recordset::Open with the stream, an empty connection ... The exception I get when trying to look in the recordset has no ...
    (microsoft.public.data.ado)
  • Re: Trouble recreating ADO recordset from XML
    ... I use rst->Save to persist the data into a _Stream object. ... Meant to add, when opening a recordset on a persisted source, those options ... have you looked at the XML? ...
    (microsoft.public.data.ado)
  • Error message when opening a recordset with a strem containing xml
    ... I have a problem when trying to open a recordset with a stream including xml ... System.String schemaText = null; ...
    (microsoft.public.data.ado)
  • Re: Easily copy a record to a table
    ... Just using Stream will not do this. ... You could use XML stream from the recordset to *switch* recordset from ... With ado I> want to use sql to query a single record from one table in a database,> and then with a few lines of code take that record and copy it to the> other identical table in the other .mdb file without using an INSERT> sql statement. ... > I just want to plop the record/recordset object field values into the> other table's fields very easily. ...
    (microsoft.public.data.ado)
  • Re: ADO Stream Error
    ... When you open an unbound stream, there is no default so it must ... > CopyTo and none of the IStreams exposed by XML objects that I've seen ... > the Locals window to view the stream object as its initialized. ... > docs I'd guess the validity will depend on the type of the node. ...
    (microsoft.public.vb.database.ado)