Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 197902 - Last Review: March 14, 2005 - Revision: 5.4
PRB: Jet 3.51 OLE DB Provider Is Not Installed With MDAC 2.1 or Later
This article was previously published under Q197902
The "3706: ADO could not find the specified provider" error appears when you try to connect to an Access database through the Jet 3.51 OLE DB provider.
MDAC 2.0 installs version 3.51 of the Jet OLE DB provider. MDAC versions 2.1 through 2.5 install version 4.0 of the Jet OLE DB provider but does not install version 3.51. MDAC 2.1 does not remove or overwrite version 3.51 of the Jet OLE DB provider if it was previously installed.
The Jet OLE DB provider requires the version number of the provider in
order to connect to an Access database.
As a result, if your application specifies version 3.51 of the Jet OLE DB
provider in the connection string and you install ADO by redistributing
MDAC 2.1, you will be unable to connect to your Access database.
The simplest workarounds are as follows:
- Redistribute MDAC 2.0 components prior to or instead of MDAC 2.1
components.
-or- - Change the connection strings in your application to use version 4.0 of the Jet OLE DB provider.
For additional information, click the article number below
to view the article in the Microsoft Knowledge Base:
240377Â
(http://kbalertz.com/Feedback.aspx?kbNumber=240377/EN-US/
)
Insuring Jet 3.5 Is Installed Correctly (Part I)
APPLIES TO
- Microsoft OLE DB Provider for Jet 4.0
- Microsoft OLE DB Provider for Jet 3.51
- Microsoft ActiveX Data Objects 2.0
- Microsoft ActiveX Data Objects 2.1
- Microsoft ActiveX Data Objects 2.5
- Microsoft Visual Basic 5.0 Professional Edition
- Microsoft Visual Basic 6.0 Professional Edition
- Microsoft Visual Basic 5.0 Enterprise Edition
- Microsoft Visual Basic Enterprise Edition for Windows 6.0
- Microsoft Access 97 Standard Edition
- Microsoft Access 2000 Standard Edition
| kbmdacnosweep kbprb KB197902 |
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