Article ID: 225042 - View products that this article applies to.
This article was previously published under Q225042
Within your MDAC code, you have multiple recordsets with the same recordset object that are created off of the same command and are also pointing to the same connection. The first recordset that is opened contains multiple recordsets within that same object. Before calling NextRecordset on that object, open another Recordset (new recordset object) and point the ActiveConnection property to the same command and connection to which at the other recordset object was pointing. This causes the following error when the Set rs = rs.NextRecordset is executed:
This error occurs in MDAC 2.0 and MDAC 2.1. It does not occur in MDAC 1.5.
error '80004005' Unspecified error
Make sure that the ActiveConnection property of the Command object for the first recordset is set only once throughout the page (especially if it contains multiple physical recordsets within the same recordset object) if the same connection is still being used.
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.
This bug was corrected in MDAC 2.5.
Steps to Reproduce Behavior
Article ID: 225042 - Last Review: October 23, 2003 - Revision: 2.1