Error Message with Distributed Queries When Using ADO

Article translations Article translations
Article ID: 276375 - View products that this article applies to.
This article was previously published under Q276375
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

SYMPTOMS

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 Service

CursorLocation : always adUseServer 
CursorType     : always adOpenStatic
					
This works correctly with only one catalog.

CAUSE

The result of the query does not contain the correct reference counting, which causes the reference count for the row to become 0 (zero).

RESOLUTION

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 the Microsoft 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
				

STATUS

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.

MORE INFORMATION

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

Properties

Article ID: 276375 - Last Review: October 21, 2013 - Revision: 3.3
APPLIES TO
  • Microsoft Windows 2000 Server
  • Microsoft Windows 2000 Advanced Server
  • Microsoft Windows 2000 Professional Edition
Keywords: 
kbnosurvey kbarchive kbhotfixserver kbqfe kbbug kbfix kbwin2000presp2fix KB276375

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com