PRB: ERR "ADO Could Not Find The Specified Provider"

ID: Q191271

The information in this article applies to:

Microsoft OLE DB Provider for ODBC, versions 1.0, 1.1, 1.5, 2.0 on the following platform: NT
Microsoft Data Access Components version 1.5

SYMPTOMS

The following error message occurs when trying to connect to SQL Server using ActiveX Data Objects (ADO):

   ADODB.Connection error '800a0e7a'
   ADO could not find the specified provider.

CAUSE

The MSDASQL OLE DB provider is either unavailable or is not registered. This can be caused by an incomplete upgrade or a bad install of the Microsoft Data Access Components (MDAC) components.

RESOLUTION

Here are two ways to resolve this problem:

      REGSVR32 "C:\Program Files\Common Files\System\ole db\MSDASQL.DLL"

Uninstall and reinstall the ODBC portion of Internet Information Server (IIS) 4.0, either through the IIS 4.0 installation or through the MDAC Update download available at the following Web address:
```
      http://www.microsoft.com/data/ado/
```

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

1. Unregister "C:\Program Files\Common Files\System\ole db\Msdasql.dll"

   using REGSVR32 from the Command line.  Here is an example:

      REGSVR32 -U "C:\Program Files\Common Files\System\ole db\MSDASQL.DLL"

2. Try to connect to the PUBS database on SQL Server using ADO.

RESULTS: The error occurs.

Additional query words: kbDSIASPGrp kbADO

Version           : WINDOWS:1.0,1.1,1.5,2.0
Platform          : WINDOWS
Issue type        : kbprb

Last Reviewed: August 13, 1998