MDAC Error Fix

There are potentially four fixes that will need to be run on your PC.
You should apply these fixes in the order shown to repair MDAC.

FIX 1: Run the MDAC Repair Tool

  1. Close all programs.
  2. Download the following file which will be used to fix your MDAC systems. Click HERE to start the download. When prompted, click Save.
  3. Select a location on your PC to where you’d like the file saved (we suggest the Windows Desktop).
  4. After the download has completed, click Open to run the file. Note: The name of the download file is: mdac_repair_xp_sp2.exe
  5. Follow the on-screen instructions to install and run the MDAC Repair Tool.
  6. Start CramMaster.
  7. If you continue to get an error message, continue with FIX 2, below.

FIX 2: Run REGSVR32

  1. Close all programs.
  2. Click Start, Run. The Run dialog box will appear, prompting you to type a file to Open.
  3. Clear anything that might already be in the Open box/field.
  4. Type: REGSVR32 “C:\Program Files\Common Files\System\ole db\MSDASQL.DLL”
  5. Click OK.
  6. You should receive a message stating the command was Successful.
  7. Start CramMaster.
  8. If you continue to get an error message, continue with FIX 3, below.

Note: All of the command should be entered on one line (it may appear on two lines, above) and be sure to include the entire string, including the quotes.

FIX 3: Update MDAC

  1. Click HERE to open a link to the Microsoft.com web site in a new window.
  2. Click the Download button on the right side of the screen.
  3. When prompted to Save or Run, click Save to save the file to your Windows Desktop.
  4. Close all running programs and disable any virus scanning software. Run (double-click) the file you just downloaded which should now be an icon on your Desktop named MDAC_TYP.exe.
  5. Follow the on-screen directions for installing MDAC 2.8.
  6. When the installation has completed, reboot your PC.
  7. Start CramMaster.

Fix 4: INF repair (Last Resort)

  1. Locate the mdac.inf file in c:\windows\inf right click and install. When prompted for a location, point to C:\windows\servicepackfiles\i386
  2. Then when prompted for the XP cd,either load the cd or point to c:\i386. This should reinstall / repairs MDAC 2.8