Select the product you need help with

Error Message with Distributed Queries When Using ADO

Article ID: 276375 - View products that this article applies to.

This article was previously published under Q276375

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.

Back to the top | Give Feedback

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).

Back to the top | Give Feedback

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

(http://support.microsoft.com/kb/260910/EN-US/ )

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

Back to the top | Give Feedback

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.

Back to the top | Give Feedback

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

(http://support.microsoft.com/kb/249149/EN-US/ )

Installing Microsoft Windows 2000 and Windows 2000 Hotfixes

Back to the top | Give Feedback