Disconnected Recordsets/Command
Hi,
I am attempting to use a disconnected recordset with a command object. I wish to:
Create a Connection object, and set it to open.
Bind the Connection object to the ActiveConnection property on a Command object.
Create a recordset and set it to the cursor returned by the Command object's Execute method.
I want the recordset to be disconnected, so I wish to close the
connection and pass the recordset back to another function.
However, when the connection's Close method is called, the recordset cannot work properly. I would set the CursorLocation property on the Recordset first, but it is instantiated by the execute method.
Does anyone have any ideas on obtaining a disconnected recordset with a command object?
Cheers,
TFA