Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 216822 - Last Review: December 5, 2003 - Revision: 4.1
PRB: Index Server: "ADO Could Not Find the Specified Provider"
This article was previously published under Q216822
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
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.
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.
This behavior is by design.
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:
For additional information about Index Server, please see the following
articles in the Microsoft Knowledge Base:
178849Â
(http://kbalertz.com/Feedback.aspx?kbNumber=178849/EN-US/
)
INFO: Index Server OLEDB Provider Cannot Be Installed Separately
For additional information on Index Server, refer to the Index Server documentation in the Windows NT Option Pack or Windows 2000 documentation. The chapter "SQL Access to Index Server Data" is the best reference for SQL query syntax for Index Server.
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
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate