This article was previously published under Q276375
This article has been archived. It is offered "as is" and will no longer be updated.
When you are using a static server cursor with the Microsoft OLE DB Provider for Microsoft Indexing Service, the second and subsequent calls to RS.Next return the following error message when you are querying multiple catalogs:
Row Handle Is Invalid.
This occurs even though the following Microsoft Platform SDK documentation has been followed:
Platform SDK Data Access Services Microsoft Data Access Components (MDAC) SDK Microsoft ActiveX Data Objects (ADO) Microsoft ADO Programmer's Reference Using Providers with ADO Microsoft OLE DB Provider for Microsoft Indexing ServiceCursorLocation : always adUseServer CursorType : always adOpenStatic
This works correctly with only one catalog.
The result of the query does not contain the correct reference counting, which causes the reference count for the row to become 0 (zero).
To resolve this problem, obtain the latest service pack for Windows 2000. For additional information, click the following article number to view the article in theMicrosoft Knowledge Base:
260910 How to Obtain the Latest Windows 2000 Service Pack
The English version of this fix should have the following file attributes or later:
Version Size File name ----------------------------------- 5.0.2195.2495 1,416,464 Query.dll
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Windows 2000 Service Pack 2.
For additional information about how to install Windows 2000 and Windows 2000 hotfixes at the same time, click the article number below to view the article in the Microsoft Knowledge Base:
249149 Installing Microsoft Windows 2000 and Windows 2000 Hotfixes