PRB: Jet 3.51 OLE DB Provider Is Not Installed With MDAC 2.1

• Microsoft OLE DB Provider for Jet, version 3.51
• ActiveX Data Objects (ADO), versions 2.0, 2.1
• Microsoft Visual Basic Professional and Enterprise Editions for Windows, versions 5.0, 6.0
• Microsoft Visual Studio versions 6.0, 97

SYMPTOMS

The "3706: ADO could not find the specified provider" error appears when trying to connect to an Access database via the Jet 3.51 OLE DB provider.

CAUSE

MDAC 2.0 installs version 3.51 of the Jet OLE DB provider. MDAC 2.1 installs 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 following:

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.

Additional query words:

Keywords : kbADO200 kbADO210 kbVBp500 kbVBp600 kbVS97 kbVS600
Version : WINDOWS:2.0,2.1,3.51,5.0,6.0,97
Platform : WINDOWS
Issue type : kbprb