## 当前位置：SQLsever提示错误“没有注册类别”的解决方案

SQLsever提示错误“没有注册类别”的解决方案

SQLsever提示错误“没有注册类别”的解决方
这个问题是因为丢失了mdac造成，所以只需要重装mdac就就可以了。

解决方法：
插入windows系统盘->进到C:\WINDOWS\inf->找到 mdac.inf ->点右键安装，按照提示安装完->重启计算机（其实不重启也可以的，但是未来保险起见）

General Information
Windows XP with Service Pack 2 contains MDAC version 2.81, which is currently not available for download at the Microsoft Web site as a standalone installation. If you try to install MDAC 2.8, which is the latest available standalone download of MDAC, you will receive a message that you already have a newer version of MDAC installed. Therefore, under Windows XP SP2, you must manually repair MDAC 2.81 as outlined below.

How to Repair MDAC 2.81 under Windows XP with SP2
1. In Windows Explorer, open the c:\Windows\Inf folder.

Note If you cannot see the c:\Windows\Inf folder, follow these steps: a. On the desktop, double-click My Computer, and then on the Tools menu, click Folder Options.
b. Click the View tab.
c. Under Advanced settings, select the Show hidden files and folders check box.
d. Clear the Hide extensions for known file types check box.
e. Click OK.

2. In the C:\Windows\Inf folder, right-click the Mdac.inf file, and then click Install.

3. When you are prompted to insert the Windows XP SP2 CD, use one of the following methods: I. If you have a Windows XP SP2 CD:
a. Insert the Windows XP Service Pack 2 CD in the CD or DVD drive.
Note If a "Welcome to Microsoft Windows XP" message appears, click Exit.
b. Click Browse.
c. In the File name box, type CD or DVD drive that contains the Windows XP Service Pack 2 CD drive letter:\i386. For example, type d:\i386 if the Windows XP Service Pack 2 CD is in drive D.
d. Click Open.

II. If you do not have a Windows XP SP2 CD:
a. In the File name box, type %systemroot%\windows\servicepackfiles\i386, and then click Open.
b. When prompted for adcjavas.inc, point to C:\Windows\servicepackfiles\i386
Note: If you cannot find this folder put the Windows CD into your CD drive and browse for that file.
c. When prompted for the file handler.reg, either point to C:\Program Files\Common Files\System\msadc, or put the Windows XP CD in your CD-ROM drive.
d. When prompted for MDACRdMe.htm, point to C:\Program Files\Common Files\System\Ado. If this file is not present rename the file MDACReadme.htm to MDACRdMe.htm.
e. When prompted for oledbjvs.inc, point to C:\Program Files\Common Files\System\Ole DB.
f. When prompted for mssoap1.dll, point to C:\Program Files\Common Files\MSSoap\Binaries.
g. When prompted for mssoapr.dll, point to C:\Program Files\Common Files\MSSoap\Binaries (or below its subfolders).

4. You may also be prompted for the original Windows XP CD that was used to install the operating system. a. Insert the Windows XP Service Pack 2 CD in the CD or DVD drive.
Note If a "Welcome to Microsoft Windows XP" message appears, click Exit.
b. Click Browse.
c. In the File name box, type CD or DVD drive that contains the Windows XP Service Pack 2 CD drive letter:\i386. For example, type d:\i386 if the Windows XP Service Pack 2 CD is in drive D.
d. Click Open.

Note: In the case you cannot find those files in the given folders search the whole hard disk for them.

Further Optional Steps