Microsoft KB Archive/216822

= PRB: Index Server: "ADO Could Not Find the Specified Provider" =

Article ID: 216822

Article Last Modified on 12/5/2003

-

APPLIES TO


 * Microsoft OLE DB Provider for Index Server 2.0
 * Microsoft OLE DB Provider for Index Server 3.0
 * Microsoft Visual Basic 5.0 Learning Edition
 * Microsoft Visual Basic 6.0 Learning Edition
 * Microsoft Visual Basic 5.0 Professional Edition
 * Microsoft Visual Basic 6.0 Professional Edition
 * Microsoft ActiveX Data Objects 2.1 Service Pack 2
 * Microsoft ActiveX Data Objects 2.5
 * Microsoft ActiveX Data Objects 2.6
 * Microsoft ActiveX Data Objects 2.7
 * Microsoft Index Server 2.0
 * Microsoft Index Server 2.0

-



This article was previously published under Q216822



SYMPTOMS
When you use ActiveX Data Objects (ADO) in a Visual Basic application to query an Index Server, you may receive the following error message:

ADO could not find the specified provider



CAUSE
The Index Server OLE DB provider (MSIDXS) is not installed on the computer. This situation applies to the case where a Visual Basic application resides on a computer that is remote to the queried Index Server. Index Server cannot be queried remotely using ADO and Visual Basic.



RESOLUTION
Install Index Server from the Microsoft Windows NT 4.0 Option Pack or Index Services from the Microsoft Windows 2000 Add Components dialog box. Use ADO within a Visual Basic application to query Index Server on the local computer.



STATUS
This behavior is by design.



MORE INFORMATION
SQL Server 7.0 also installs the OLE DB provider for Microsoft Index Server. However, you can not directly use the provider from a consumer such as ADO to perform a query without first installing Index Server on the same computer. You might see the following error if you run a Visual Basic ADO application that tries to open a connection using MSIDXS provider on a computer where SQL Server 7.0 was installed but Index Server was not:

Service is not running

