Error Message with Distributed Queries When Using ADO (276375)

The information in this article applies to:

Microsoft Windows 2000 Server
Microsoft Windows 2000 Advanced Server
Microsoft Windows 2000 Professional

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.

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

Modification Type:	Minor	Last Reviewed:	9/26/2005
Keywords:	kbHotfixServer kbQFE kbbug kbfix kbWin2000PreSP2Fix KB276375