Re: Trouble recreating ADO recordset from XML


<muybluie@xxxxxxxxxxx> wrote in message
news:1191249717.172434.97470@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello All,

I have two modules running on two different processes; they use COM to
communicate.

One module retrieves recordsets from an Oracle datasource, persists
them into an XML stream, and then sends them to the second module.
the second module then takes the stream and converts it back to a
recordset.

While this works on most machines, one set of machines is having
trouble with this. Although Open returns S_OK, any attempts to access
the recordset throw exceptions. The recordset does not seem to be
NULL.

Any ideas on what's going on?

Thanks,
Ergo


I would like to play, and I'm sure others would like to as well, but you
have to provide more information. What exceptions? How are you creating the
xml - rc.Save? What streams - ADO object? Something you created? What Open?
....

-ralph


.

Relevant Pages

  • 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: Recordset load XML
    ... file, if you are using a version of ADO that supports the Stream object, you ... new Recordset ... Recordset return so I save the RecordSet to an XML string: ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: How to clone recordset...
    ... You could load from the stream, but question is how you pass this stream to ... "Vladimir Korobov" wrote in message ... >> recordset and you could create it using Clone method of ADO recordset. ...
    (microsoft.public.data.ado)
  • Read from image file into IMAGE column
    ... I got the recordset to read from the stream.. ... I also got the recordset to write to the SQL image field. ... Dim fLen As Integer ...
    (microsoft.public.access.adp.sqlserver)