Reinstalling MDAC in XP SP3

I had a customer that just couldn’t get MDAC to work under XP. Reinstalling XP SP3 didn’t work. Microsoft doesn’t make anything available to reinstall MDAC individually. So it’s a complete nightmare to fix it. Luckily, I was able to solve the issue with these steps:

1. Click Start > Run and type %windir%\inf and click OK.

2. Right-click mdac.inf and select Install.

This is where the nightmare started for me. I didn’t have any of the files below. I had to copy the OLE DB, msadc, Ole DB and Binaries folders from another computer and place them in the C:\Program Files\Common Files\System\ folder. If you are missing the servicepackfiles folder, you will have it after you reinstall XP Service Pack 3. You can also just extract the files from the SP3 file by using the windowsxp-kb936929-sp3-x86-enu.exe –x command.

3. When prompted for each of the following files, try to browse and locate them in the directories specified.

  • adcjavas.inc – C:\Windows\servicepackfiles\i386
  • handler.reg – C:\Program Files\Common Files\System\msadc
  • MDACRdMe.htm – C:\Program Files\Common Files\System\AdoI had to rename MDACReadme.htm to MDACRdMe.htm first.
  • oledbjvs.inc – C:\Program Files\Common Files\System\Ole DB
  • mssoap1.dll – C:\Program Files\Common Files\MSSoap\Binaries
  • mssoapr.dll – C:\Program Files\Common Files\MSSoap\Binaries

After all these steps, MDAC was working again.

This article was adapted from the article How to Repair MDAC 2.8 Under Windows XP with SP2 Installed. They also have a pretty useful MDAC repair tool, although it didn’t work for me in this case.

Comments

  1. Renato says

    I fixed the problem, thanks, just mssoapr.dll file was missed, and i downloaded it from the web. Work perfectly ! Just one question i have also extracted the WIN XP SP3 in a temporary folder, where are these files or how can i reinstal ODBC MDAC from it ?

  2. vlad says

    Dear Mitch,
    In your article you write:
    “Copy the OLE DB, msadc, Ole DB and Binaries folders from another computer and place them in the C:\Program Files\Common Files\System\ folder”.
    But I can not copy Ole Db, Ado, msadc folders to the C:\Program Files\Common Files\System\ folder, because these folders already exist.
    May I copy it in C:\Program Files\Common Files\System\temp folder?
    Many Thanks,

  3. andrea says

    Thanks a lot…
    Perfect solution.
    I didn’t find the mssoapr.dll in C:Program FilesCommon FilesMSSoapBinaries but in C:Program FilesCommon FilesMSSoapBinariesResources1033.
    Anyway… I solved.
    Thanks a lot again

  4. Did says

    excellent. I succeeded to reinstall MADC under Windows XP SP3 and I solved my problem for IZispot. the only difference is that I found the last file mssoapr.dll in directory C:\Program Files\Common Files\MSSoap\Binaries\Resources\1033.
    thank you very much for this great topic

  5. Chan says

    This fixed a problem I had with my Virtual XP machine on Win7. I had a problem with an error coming from ADODB.Properties(“Output Stream”) when trying to a stream a xml output. Spent hours and hours trying to find a solution and finally reinstalling mdac sovled my problem. Thanks Mitch.

  6. James says

    This fixed the problem i had with Dynamics FRX 6.7 install. After running thru these instructions i no longer go the error install assist error, and the installation would finish!! Thanks!

  7. Divya Rathi says

    This is the perfect soultion . My machine had got upgraded to XP SP3 and post that my application could not create linked tables in MS Access. I reinstalled MDAC and problem is resolved

  8. Rahul says

    I tried something differnt i have XP SP3 CD , I just run the above mentioned mdac.inf and then Giveen only one path G:\I386 folder , Thats work for me , I needed MDAC for load runner, Thanks a ton for your help.

    It really saves lots of time for me

  9. Vigilance says

    YOU THA MAN/WOMAN, THAN YOU VERY MUCH. Saved me having to reinstall the whole operating system again.Don’t know why it corrupted though, if you know post it, pls.

  10. Japie Die Skapie says

    Thanks, this saved us a lot of time.
    The only thing that I had to change was the one path :

    mssoapr.dll – “C:\Program Files\Common Files\MSSoap\Binaries\Resources\1033″

    and you should also mention that you need to restart the computer for it to start working again.

    Thanks again.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>