Is it not possible to create a disconnected ado recordset in testcomplete?

I need to create an ado recordset that allows me to continue to use the recordset without an active connection to the data. Is this possible? The standard method to do this is to set the 'cursorlocation' property of the recordset to 'aduseclient'. Then you should be able to set the 'activeconnection' property to 'nothing' and continue to use the data. That's the way I understand it anyway.



Yet, when I attempt to do this in Testcomplete I get ...

'operation is not allowed when the object is open'

... error on the 'Set rs.activeconnection = Nothing' line.



If I supress the error and close the connection, the very next line that attempts to retrieve the 'recordcount' value from the recordset returns ...

'operation is not allowed when the object is closed'.