If you are having problems with an application that uses MDAC in Windows XP with Service Pack 2 (SP2), you might need to re-install 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 disc. When prompted for the XP installation media, point to the i386 folder in one of these places:
- C:\WindowsServicepackFiles\i386 (it may not like this location, if not, go to the next one)
- The i386 folder on your XP installation CDROM. This re-installs and repairs MDAC 2.8.