Pass recordset out of process

From: Mark Guerrieri (mguerrieri_at_nospam_cmsgrp.com)
Date: 02/22/05


Date: Mon, 21 Feb 2005 22:19:00 -0500

I have an out-of-process server that implements an object with a 'Recordset'
property. It is implemented as an IDispatch* [out, retval] property. I
have also tried VARIANT* [out, retval]. When a client such as VbScript uses
this property, it appears that a copy of the internal recordset is
marshalled to the client, and no changes made in the client are visible to
the underlying recordset stored in the OOP server.

So how can I pass a recordset out of the OOP server and allow VBScript to
edit it and have the underlying recordset in the server update as well?

I am trying to allow a web page to use RDS and data binding to edit the
fields of the recordset, which works fine, except that only a local copy of
the recordset is ever modified.

I also tried adding a GetRecordset method with a VARIANT* [in, out]
parameter, but that showed the same behavior.

Can I pass a REFERENCE of my recordset out of process, or only a COPY?

Mark



Relevant Pages

  • Re: DCOM and ADODB.RecordSet
    ... I have a client EXE on a user's PC connecting to a variety ... of DLLs running on a separate server using DCOM. ... Since you are marshaling the Recordset cross-process you must pass it ByVal. ...
    (microsoft.public.vb.com)
  • RE: TransferText from a table with a selection-parameter
    ... > temporary table where I store the recordset inside because there may be ... Each of your users can use separate temp tables in your SQL Server database. ...
    (microsoft.public.access.modulesdaovba)
  • Re: cancel ADO2.8 asynchron queries over WAN, takes long time
    ... > the .open method first creates the recordset at the server. ... I use clientside cursor to minimalize the traffic... ... client because they generate all sorts of activity between client and ...
    (microsoft.public.data.ado)
  • Re: cancel ADO2.8 asynchron queries over WAN, takes long time
    ... > the .open method first creates the recordset at the server. ... I use clientside cursor to minimalize the traffic... ... client because they generate all sorts of activity between client and ...
    (microsoft.public.sqlserver.programming)
  • Re: cancel ADO2.8 asynchron queries over WAN, takes long time
    ... > the .open method first creates the recordset at the server. ... I use clientside cursor to minimalize the traffic... ... client because they generate all sorts of activity between client and ...
    (microsoft.public.vb.database.ado)