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

Back to the top

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

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 (http://msdn2.microsoft.com/en-us/data/aa937695.aspx)

Back to the top

This behavior is by design.

Back to the top

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