MDAC version

Take a look at

http://www.microsoft.com/data/MDAC21info/MDACinstQ.htm

which has a table that will show you the files to look for.

You can find the details for the MDAC components from the URls given below:

http://www.microsoft.com/data/download.htm
http://is-it-true.org/nt/atips/atips297.shtml
http://is-it-true.org/nt/atips/index.shtml

If you have the WinNT Resource Kit installed, you'll find a program called "depends.exe" on your system. You can use this program to find out a wealth of information about any of the .DLL's on your system.

If you use it to view the ADO .DLL's onyour server, you'll know EXACTLY what versions they are. Then, you can use one of the other URL's mentioned to verify that your .DLL's are the ones you need.

Finally, there is no simple way to verify the correct MDAC installation, except to use the install utility to reinstall the files. This is also the only simple, sure-fire way to make sure they are installed and registered correctly.

Check the version of the file below:
C:\Program Files\Common Files\System\ado\msado15.dll

This is the quick easy way. For instance, I have .NET installed which upgrades MDAC to version 2.7. This file's version is 2.7. I learned about this from the MS knowledge base.