Microsoft KB Archive/191271

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

Article ID: 191271

Article Last Modified on 5/17/2007

-

APPLIES TO


 * Microsoft Data Access Components 1.5
 * Microsoft Data Access Components 2.0
 * Microsoft Data Access Components 2.1
 * Microsoft Data Access Components 2.5
 * Microsoft Data Access Components 2.6
 * Microsoft Data Access Components 2.7
 * Microsoft Data Access Components 2.8

-



This article was previously published under Q191271



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:  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:

http://msdn2.microsoft.com/en-us/data/aa937695.aspx





STATUS
This behavior is by design.



Steps to Reproduce Behavior
 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"

 Try to connect to the PUBS database on SQL Server using ADO.</li></ol>

RESULTS: The error occurs.

Additional query words: kbDSIASPGrp kbADO

Keywords: kbdatabase kbprb KB191271

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.