Problem installing MDAC on Windows 2000

[BukHix]

It hasn't been easy but I have managed to get the .Net Framework and SQL Server 7 set up on a test domain controller. Both are working correctly independently but when I try and view a page that shows db schema I get this error:

The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data Access Components(MDAC) version 2.6 or later.

I have tried loading MDAC 6 and 7 but both get near the end of the installation and then stop. The setup wizard says the install is being rolled back and to contact the software vendor. I have found two KB articles and went through all the suggestions and still couldn’t get it to work.

HOWTO: MDAC Setup Troubleshooting Guide (Q232060)
INFO: Component Checker: Diagnose Problems and Reconfigure MDAC Installations (Q307255)

The second KB article basically says that MDAC can not be replaced/repaired without reinstalling the operating system. Has anybody else seen this and know away around it?

By the way it is Windows 2000 with SP2 and SQL 7 with SP3 installed. Also I know the page works because it was built and tested on another workstation.

 

[BukHix]

I finaly figured this out. The solution that worked for me can be found here:

MDAC Fix

But it breaks down to this -

Q: "Installation of the Microsoft Data Access Components package failed. (-1)"-- Error occurs during setup ?

A:Some workarounds...

Sugg1
-----
Check and see if the registry key

'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup\Exceptio
nComponents'

exists on the server. If it does, then you will need to
delete this key, and re run the setup. Before deleting the key, make sure
you backup the registry in case you need to restore the key. It seems
there was a previous install of MDAC that did not complete successfully or
completely