Reinstalling MDAC 2.81 in Windows XP Service Pack 2 (SP2)
Posted on Nov 18, 2007 under Windows XP Tips |If you are having problems with an application that uses MDAC in Windows XP with Service Pack 2 (SP2), you might need to reinstall MDAC. As of this writing, a download and install is not available from Microsoft, so you must follow these instructions.
Right-click on C:\Windows\Inf\mdac.inf and choose “Install“. When prompted for the XP SP2 media, point to the i386 folder in one of these places:
1. The i386 folder on the XP SP2 CDROM. If you are unlucky enough to have a CDROM that has XPSP2.EXE in the root of the CDROM, and no i386 folder, then you will have to create an i386 folder using a command like this, XPSP2.EXE /X:C:\XpSp2 Then point to C:\XpSp2\i386.
2. The i386 folder on a slipstreamed XP SP2 installation CDROM. When prompted for the XP installation media, point to the i386 folder in one of these places:
a. C:\WindowsServicepackFiles\i386 (it may not like this location, if not, go to the next one)
b. The i386 folder on your XP installation CDROM. This reinstalls and repairs MDAC 2.8.

by ali asgar, on February 15 2008 @ 11:43 pm
Thanks for such an easy method…