How do you disconnect recordsets that were opened this way in ADO...
C++
_CommandPtr pCommand;
pCommand.CreateInstance(--
--);
pCommand->ActiveCommand = pConn;
....
_RecordsetPtr pRset;
pRset.CreateInstance(----)
;
pRset->CursorLocation = adUseClient;
pRset->Open(_variant_t((ID
ispatch*)p
Command),
vtMissing, adOpenStatic,
adLockBatchOptimistic, adCmdUnspecified);
VB
Dim command AS ADODB.Command
Dim recordset AS ADODB.Recordset
Set command = New ADODB.Command
command.ActiveConnection = conn
...
Set recordset = New ADODB.Recordset
recordset.open command,,adOpenStatic,
adLockBatchOptimistic, adCmdUnspecified
How to set the ActiveConnection property of pRset to NULL or nothing. Do I use the command object that I opened it with?
Start Free Trial