How do you repair MDAC 2.8 on Win2003?

[abacnet]

This site http://support.microsoft.com/?kbid=828396 says the following
"If you try to run the 2.8 MDAC_TYP.exe file on a computer that is running
Windows Server 2003,
installation of the MDAC components appears to complete successfully.
However, no files are updated on your system. This behavior occurs because
by default, Windows Server 2003 includes the MDAC 2.8 components."

So the question is still then how do we do it when some files are corrupted?

[Jim Martin [MSFT]]

Try this:

1. Check the file versions of C:\Program Files\Common Files\System\Ole
DB\oledb32.dll and oledb32r.dll.

They should both be 2.80.1022.0 in a default installation of SBS 2003.
Sometimes these files are not updated during an upgrade, perhaps due to the
file being
locked by a third party program.

3. Get the 2.80.1022.0 version of the oledb32.dll and/or loedb32r.dll file.

a. You can get this file by expanding it from the SBS 2003 CD #1:\i386
folder.

b. You can download MDAC 2.8 from www.microsoft.com to the hard drive. You
can
search for "mdac 2.8" or us the link
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-
b037-185
d0506396c&DisplayLang=en

If you download mdac 2.8 from the Microsoft website, you will need to then
extract
the files by running "mdac_typ.exe /C /T:C:\mdac2.8" to extract the files
to the
C:\mdac2.8 folder. You do not need to create this folder and it is used for
illustration purposes only.

Browse to C:\mdac2.8\mdacxpak.cab and extract the oledb32.dll or
oledb32r.dll file.

4a. Delete the C:\winnt\system32\dllcache\oledb32.dll or oledb32r.dll file
and place a copy of the
2.80.1022.0 version of the file in the C:\winnt\system32\dllcache folder.

4b. Rename the C:\Program Files\Common Files\System\Ole DB\oledb32.dll or
oledb32r.dll file and
place a copy of the 2.80.1022.0 version of the file in this folder.

5. Register the updated dll file using the following command.
regsvr32 C:\Program Files\Common Files\System\Ole DB\oledb32.dll (or
oledb32r.dll)

Jim Martin, MCSE, MCP+I, A+
Microsoft Corporation

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

[abacnet]

Hi Jim,

So there is no other professional way of updating MDAC 2.8 on Windows 2003
without going individually on a dll, deleting it, copying another one and
registering it manually?

"Jim Martin [MSFT]" <a-jm...@online.microsoft.com> wrote in message
news:qVXe%23jnRE...@cpmsftngxa10.phx.gbl...

[Jim Martin [MSFT]]

Sorry, but from everything I have read it appears that MDAC 2.8 is deeply
integrated into the OS in 2003, so there is no way to uninstall then
reinstall MDAC as a complete component. The best thing I can offer is to
run the Component Checker Tool to verify your individual MDAC components,
then repair them individually as needed.