PRB: Jet 3.51 OLE DB Provider Is Not Installed With MDAC 2.1 or Later (197902)
The information in this article applies to:
- Microsoft OLE DB Provider for Jet 4.0
- Microsoft OLE DB Provider for Jet 3.51
- ActiveX Data Objects (ADO) 2.0
- ActiveX Data Objects (ADO) 2.1
- ActiveX Data Objects (ADO) 2.5
- Microsoft Visual Basic Professional Edition for Windows 5.0
- Microsoft Visual Basic Professional Edition for Windows 6.0
- Microsoft Visual Basic Enterprise Edition for Windows 5.0
- Microsoft Visual Basic Enterprise Edition for Windows 6.0
- Microsoft Access 97
- Microsoft Access 2000
This article was previously published under Q197902 SYMPTOMS
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.
CAUSE
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.
RESOLUTION
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.
REFERENCESFor additional information, click the article number below
to view the article in the Microsoft Knowledge Base:
240377 Insuring Jet 3.5 Is Installed Correctly (Part I)
| Modification Type: | Minor | Last Reviewed: | 3/14/2005 |
|---|
| Keywords: | kbMDACNoSweep kbprb KB197902 kbAudDeveloper |
|---|
|