Error Message with Distributed Queries When Using ADO

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

Article ID: 276375 - Last Review: 10/21/2013 02:34:31 - Revision: 3.3

Microsoft Windows 2000 Server, Microsoft Windows 2000 Advanced Server, Microsoft Windows 2000 Professional Edition

  • kbnosurvey kbarchive kbhotfixserver kbqfe kbbug kbfix kbwin2000presp2fix KB276375