Hi,
I am developing MTS components in VC++. The component methods return recordsets. For that I am opening a connection to database and then opening the recordset against the connection object i created. Once the recordset has been opened, I would like to close the connection object and set the connection pointer to null before returning from the methods. Basically I want to return a disconnected recorset. But VC++ doesn't allow me close the connection object. I have to keep the connection object till my client uses the recordset. Incase of VB I am able to close the connection object and return the recordset. Why this is not possible in VC++.

Can anyone throw light on creating Disconnected recordsets in VC++, their uses ( advantages).??

Thanks & regards

Kishore