The problem that has been depressing for a long time has finally been solved. Some solutions have been found on the internet, but most of them have not solved the problem, for reference (ADO cocould Not Find The Specified Provider)

Document directory

• Steps to Reproduce Behavior

PRB: ERR "ADO cocould Not Find The Specified Provider" View products that this article applies.

Article ID	:	191271
Last Review	:	November 3, 2003
Revision	:	3.1

This article was previusly published under q191_1on This Page

	SYMPTOMS
	CAUSE
	RESOLUTION
	STATUS
	MORE INFORMATION
		Steps to Reproduce Behavior
	APPLIES

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

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

CAUSEThe 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.

 

RESOLUTIONHere 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://msdn.microsoft.com/library/default.asp? Url =/downloads/list/dataaccess. asp (http://msdn.microsoft.com/library/default.asp? Url =/downloads/list/dataaccess. asp)

 

STATUSThis 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.

 

APPLIES

•	Microsoft Data Access Components 1.5
•	Microsoft Data Access Components 2.0
•	Microsoft Data Access Components 2.1
•	Microsoft Data Access Components 2.8
•	Microsoft Data Access Components 2.6
•	Microsoft Data Access Components 2.7
•	Microsoft Data Access Components 2.8

The above is the solution on the Microsoft English webpage, but the Chinese webpage does not exist. Alas, there is no way. In fact, it is to re-register a data access component, I believe many people have encountered such problems. I hope it will be useful to everyone.
It provides two solutions,
One is:

•	Register the Msdasql. dll using the following command: REGSVR32 "C: \ Program Files \ Common Files \ System \ ole db \ MSDASQL. DLL"

Register this data access component again with REGSVR32 "C: \ Program Files \ Common Files \ System \ ole db \ MSDASQL. DLL"

The second is to download and reinstall this component:
Reinstall the Microsoft Data Access Components used. The newest version of MDAC can be downloaded from the following Web site:

Http://msdn.microsoft.com/library/default.asp? Url =/downloads/list/dataaccess. asp (http://msdn.microsoft.com/library/default.asp? Url =/downloads/list/dataaccess. asp)

In fact, I have downloaded a 2.8 version and re-installed it, but it does not work. Haha. So I was depressed for a long time.