让人郁闷了好久的问题，终于解决了，之前网上也看到一些解决方法，但大多没有解决问题，所以记录下来，以供参考之用（ADO Could Not Find The Specified Provider）

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

View products that this article applies to.

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

This article was previously published under Q191271

On This Page

	SYMPTOMS
	CAUSE
	RESOLUTION
	STATUS
	MORE INFORMATION
		Steps to Reproduce Behavior
	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.

 

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

 

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.

 

---

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.8
•	Microsoft Data Access Components 2.6
•	Microsoft Data Access Components 2.7
•	Microsoft Data Access Components 2.8

上面是微软英文网页上面的解决方法，可是中文网页上面是没有的，唉，没办法啊，其实就是重新注册一下一个数据访问组件，相信很多人都遇到过这样的问题。希望对大伙有用吧。
它提供了两种解决方法，
一种是：

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

用 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)

其实之前我也下载过一个2.8的版本重新安装过，可是没有起作用。呵呵。所以才郁闷了好久的。