Installing MDAC 2.5 on W2k sp3

I have tried installing MDAC 2.5 on a w2k sp3 machine and it fails with the following error:

Microsoft Data Access components 2.5 is already installed on the version of windows you are running. Setup cannot update the system. For more information .....

BUT, Mdac 2.5 is not installed on the machine and VB applications using it do not work.

Any ideas?

ThankQ1 Any ideas?

A1 Yes.

1 Check your MDAC component status with the compatibility checking tool. See:

http://www.microsoft.com/data/download.htm#CCinfo

http://download.microsoft.com/download/dasdk/CC/2.7/WIN98MeXP/EN-US/cc.exe

2 See MDAC Installation Notes at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html/data_mdacinstall.asp|||Thanks DBA,

This has let me discover that the latest PCs with W2k have sp3 installed by default which includes MDAC 2.6. It is therefore not possible to install MDAC 2.5 - it physically stops you.

It just means I have to change the references to the ADO 2.5 objects to 2.6...|||You are most welcome.

Hopefully 2.6 is otherwise fully compatible with your applications. Newer (and sometimes corrupt or third party) dll issues are not an uncommon source of spurious "already installed" and similar MDAC errors.sql