Doubt

[itsnaveen]

What does disconnected recordset mean???

[Guv]

I copied the following from MSDN. It is not the complete article. [quote]
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 discusses what a disconnected recordset is and the differences in implementation.

MORE INFORMATION
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 Recordsets
There are four techniques you could use to pass a disconnected recordset to a remote client. [/code]
The four techniques mentioned in last sentence and other verbiage are not included.

I hope the above helps.