BUG: Error Disassociating Resultset from rdoConnectionLast reviewed: September 18, 1997Article ID: Q173991 |
The information in this article applies to:
SYMPTOMSAttempting to disassociate a Resultset based on a parameterized rdoQuery object by setting the Resultset's ActiveConnection property to Nothing will result in an error:
Run-Time Error '40070': This property or method is not supported when using the currently selected cursor library. CAUSEThis problem occurs when the Resultset is based on a parameterized rdoQuery object. It also occurs using the UserConnection object with the same circumstances.
RESOLUTIONThe only workaround is to not use a parameterized rdoQuery object to create a Resultset. You can set the Resultset ActiveConnection property to Nothing if: - The Resultset is based on a SQL Select statement or a non-parameter rdoQuery, - and -- the CursorDriver is rdUseClientBatch, the type is rdOpenStatic, and the locktype is rdConcurBatch. STATUSMicrosoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. We are researching this bug and will post new information here in the Microsoft Knowledge Base as it becomes available.
MORE INFORMATION
Steps to Reproduce Behavior
Keywords : vb5all Version : WINDOWS:5.0 Platform : NT Win95 WINDOWS Issue type : kbbug |
================================================================================
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |