Skip to end of metadata
Go to start of metadata

Overview

Microsoft Windows XP with Service Pack 2 contains MDAC (Microsoft Data Access Components) 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 v2.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

In Windows Explorer, open the C:\Windows\Inf folder.  Right click the Mdac.inf file and then click Install.  When prompted to insert the Windows XP SP2 CD, use one of the following methods:

If you have a Windows XP SP2 CD
  1. Insert the Windows XP SP2 CD.
  2. If the “Welcome Microsoft Windows XP” message appears, click Exit.
  3. Click Browse.
  4. In the File name box, enter the drive letter which corresponds to the CD and the i386 folder.  For example, “F:\i386”
  5. Click Open.
If you do not have a Windows XP SP2 CD
  1. In the File name box type %systemroot%\windows\serviceoackfiles\i386 and click Open.
  2. When prompted for adcjavas,inc, point to C:\windows\servicepackfiles\i386.
  3. When prompted for the file handler.reg, point to C:\Program Files\Common Files\System\msdac.
  4. 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.
  5. When prompted for oledbjvs.inc, point to C:\Program Files\Common Files\System\Ole DB.
  6. When prompted for mssoap1.dll, point to C:\Program Files\Common Files\MSSoap\Binaries.
  7. When prompted for mssoapr.dll, point to C:\Program Files\Common Files\MSSoap\Binaries.
You may also be prompted for the original Windows XP CD that was used to install the operating system
  1. Insert the Windows XP CD in the CD or DVD drive.
  2. If the "Welcome to Microsoft Windows XP" message appears, click Exit.
  3. Click Browse.
  4. 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.
  5. Click Open.

Further Updates