Article ID: 190717 - View products that this article applies to.
This article was previously published under Q190717
This article has been archived. It is offered "as is" and will no longer be updated.
With the introduction of the Advanced Data Connector (later renamed the Remote Data Services of ActiveX Data Objects [ADO]), it is possible to create a disconnected recordset. In addition, the Distributed Component Object Model (DCOM) allows you to marshall COM objects across computer boundaries, providing similar (but not identical) functionality to Remote Data Service (RDS).
This article describes what a disconnected recordset is and the differences in implementation.
Disconnecting a recordset means you can view the recordset's data after severing the connection to the data store that generated the recordset. You can create a disconnected ADO recordset in process with a recordset whose CursorLocation property is adUseClient and whose ActiveConnection property is set to NULL/Nothing. You can then pass this recordset to a remote client using either RDS or DCOM (or both together).
In ADO, you generate the recordset normally, as you would any other recordset, then disconnect it from the connection by setting the Recordset.ActiveConnection property to NULL/Nothing. Then you can close the Connection object.
In RDS, you generate an ADO recordset by requesting it through the use of RDS client components.
Techniques to Pass Disconnected RecordsetsThere are four techniques you could use to pass a disconnected recordset to a remote client.
You can download Data Access SDK 2.0 from the following Web site:
http://msdn2.microsoft.com/en-us/data/aa937695.aspxYou can obtain the "Whats New in ADO 2.0" white paper from the following Web site:
http://msdn.microsoft.com/library/For additional information, please see the following articles in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/183609/EN-US/ )FILE: Rdsvb.exe Demonstrates How to Use RDS with Visual Basic
(https://support.microsoft.com/kb/183628/EN-US/ )HOWTO: Using the RDS DataFactory via Standard ADO Open Method
(https://support.microsoft.com/kb/182442/EN-US/ )FILE: Adomts.exe Shows Using ADO w/ an MTS component via DCOM
(https://support.microsoft.com/kb/175510/EN-US/ )FILE: VB5DCOM.EXE: Using Callbacks and WithEvents with DCOM