Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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.

↑ Back to the top


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.

↑ Back to the top


Resolution

Here are two ways to resolve this problem:
  • Register the Msdasql.dll using the following command:
    REGSVR32 "C:\Program Files\Common Files\System\ole db\MSDASQL.DLL"
  • Reinstall the Microsoft Data Access Components used. The newest version of MDAC can be downloaded from the following Web site:

↑ Back to the top


Status

This behavior is by design.

↑ Back to the top


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.

↑ Back to the top


Keywords: KB191271, kbprb, kbdatabase

↑ Back to the top

Article Info
Article ID : 191271
Revision : 6
Created on : 5/17/2007
Published on : 5/17/2007
Exists online : False
Views : 496