Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MDAC
- Thread starter annub
- Start date
I'm going to put it up as an FAQ - but I have this document - hopefully it will help
HOW TO: Check for MDAC Version
--------------------------------------------------------------------------------
The information in this article applies to:
Microsoft Data Access Components versions 2.1 , 2.1 (GA) , 2.1 SP1 , 2.1 SP2 , 2.5 , 2.5 SP1 , 2.5 SP2 , 2.6 , 2.6 SP1
--------------------------------------------------------------------------------
IN THIS TASK
SUMMARY
Install and Use the Component Checker Tool
Check the Version Information Stored in the Registry
Troubleshooting
SUMMARY
This article describes two different ways to check which version of Microsoft Data Access Components (MDAC) is installed on a system:
Using the Component Checker tool.
Checking the version information that is stored in the registry.
back to the top
Install and Use the Component Checker Tool
The most reliable way to determine which version of MDAC is installed is to compare the version number of each MDAC DLL file to a list of the DLL files that are shipped with each MDAC version. The Component Checker can help you to do this. It checks the files on the computer, compares them to a list from each version of MDAC, and reports the closest match.
To install Component Checker, follow these steps:
Browse to the following Microsoft Web site:
Click the link to download Component Checker. When prompted by the browser, save Cc.exe (a self-extracting executable file) to the desktop.
On the desktop, double-click Cc.exe; this extracts the Component Checker files and installs to the default location, C:\Comcheck.
To use Component Checker to check the MDAC version, follow these steps:
From the Start menu, click Run .
In the Open text box, type c:\comcheck\comcheck.exe and then click OK .
In the Component Checker - Choose Analysis Type dialog box, select Perform Analysis of your machine and automatically determine the release version , and then click OK .
The program attempts to identify the MDAC version on your computer by scanning all of the core MDAC files and registry settings. This process normally takes several minutes. When finished, you should receive the following message:
The MDAC version that is closest to the version on your computer is 'XXXX'.
Click OK .
A summary of the Component Checker scan appears. Note that the Dir, FileDescription, and FileSize errors can be safely ignored.
back to the top
Check the Version Information Stored in the Registry
Although not the most reliable way to check the MDAC version, checking the registry for the version information is an easy way to double-check this information (if you are not experiencing any MDAC-related issues).
The version information is found in the following keys:
HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer
HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\Version
To check the registry, follow these steps:
On the Start menu, click Run .
In the Open text box, type regedit and then click OK ; this starts Registry Editor.
In the Navigation pane, drill-down to the following path:
HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess
In the Details pane, look in the Name column for FullInstallVer and Version . Each of these keys will have corresponding version information in the Data column.
When finished, click Exit on the Registry menu to close Registry Editor.
back to the top
Troubleshooting
Note that the version information stored in the registry may be incorrect for versions of MDAC prior to 2.1 when compared with the versions of the actual files. Windows 2000 installs version 2.5. Only versions of MDAC later than 2.5 may be installed on Windows 2000.
Downloads for Microsoft Data Access Components are available at the following Web site:
back to the top
--------------------------------------------------------------------------------
Additional query words :
Keywords : kbAudDeveloper kbHOWTOmaster
Issue type : kbhowto
Last Reviewed: November 2, 2001
©2002 Microsoft Corporation. All rights reserved. Terms of Use. | Accessibility | Privacy Statement
Article ID: Q301202
Last Reviewed:
November 2, 2001
Send to a friend
Provided by
Microsoft Product Support Services
--------------------------------------------------------------------------------
Did the information in this article help answer your question?
Yes
No
Did not apply
Please provide additional comments about this information.
(255 character max)
HOW TO: Check for MDAC Version
--------------------------------------------------------------------------------
The information in this article applies to:
Microsoft Data Access Components versions 2.1 , 2.1 (GA) , 2.1 SP1 , 2.1 SP2 , 2.5 , 2.5 SP1 , 2.5 SP2 , 2.6 , 2.6 SP1
--------------------------------------------------------------------------------
IN THIS TASK
SUMMARY
Install and Use the Component Checker Tool
Check the Version Information Stored in the Registry
Troubleshooting
SUMMARY
This article describes two different ways to check which version of Microsoft Data Access Components (MDAC) is installed on a system:
Using the Component Checker tool.
Checking the version information that is stored in the registry.
back to the top
Install and Use the Component Checker Tool
The most reliable way to determine which version of MDAC is installed is to compare the version number of each MDAC DLL file to a list of the DLL files that are shipped with each MDAC version. The Component Checker can help you to do this. It checks the files on the computer, compares them to a list from each version of MDAC, and reports the closest match.
To install Component Checker, follow these steps:
Browse to the following Microsoft Web site:
Click the link to download Component Checker. When prompted by the browser, save Cc.exe (a self-extracting executable file) to the desktop.
On the desktop, double-click Cc.exe; this extracts the Component Checker files and installs to the default location, C:\Comcheck.
To use Component Checker to check the MDAC version, follow these steps:
From the Start menu, click Run .
In the Open text box, type c:\comcheck\comcheck.exe and then click OK .
In the Component Checker - Choose Analysis Type dialog box, select Perform Analysis of your machine and automatically determine the release version , and then click OK .
The program attempts to identify the MDAC version on your computer by scanning all of the core MDAC files and registry settings. This process normally takes several minutes. When finished, you should receive the following message:
The MDAC version that is closest to the version on your computer is 'XXXX'.
Click OK .
A summary of the Component Checker scan appears. Note that the Dir, FileDescription, and FileSize errors can be safely ignored.
back to the top
Check the Version Information Stored in the Registry
Although not the most reliable way to check the MDAC version, checking the registry for the version information is an easy way to double-check this information (if you are not experiencing any MDAC-related issues).
The version information is found in the following keys:
HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer
HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\Version
To check the registry, follow these steps:
On the Start menu, click Run .
In the Open text box, type regedit and then click OK ; this starts Registry Editor.
In the Navigation pane, drill-down to the following path:
HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess
In the Details pane, look in the Name column for FullInstallVer and Version . Each of these keys will have corresponding version information in the Data column.
When finished, click Exit on the Registry menu to close Registry Editor.
back to the top
Troubleshooting
Note that the version information stored in the registry may be incorrect for versions of MDAC prior to 2.1 when compared with the versions of the actual files. Windows 2000 installs version 2.5. Only versions of MDAC later than 2.5 may be installed on Windows 2000.
Downloads for Microsoft Data Access Components are available at the following Web site:
back to the top
--------------------------------------------------------------------------------
Additional query words :
Keywords : kbAudDeveloper kbHOWTOmaster
Issue type : kbhowto
Last Reviewed: November 2, 2001
©2002 Microsoft Corporation. All rights reserved. Terms of Use. | Accessibility | Privacy Statement
Article ID: Q301202
Last Reviewed:
November 2, 2001
Send to a friend
Provided by
Microsoft Product Support Services
--------------------------------------------------------------------------------
Did the information in this article help answer your question?
Yes
No
Did not apply
Please provide additional comments about this information.
(255 character max)
umm... or you could just search for "msado15.dll" (i think thats the one) right click goto properties and click the version tab!
good luck!
If somethings hard to do, its not worth doing - Homer Simpson
------------------------------------------------------------------------
A General Guide To Excel in VB FAQ222-3383
good luck!
If somethings hard to do, its not worth doing - Homer Simpson
------------------------------------------------------------------------
A General Guide To Excel in VB FAQ222-3383
Well, there are tools from MS to see what has been installed and which fields are missing, etc.
But the easiest way is to look in a VB project under PROJECT|REFERENCES and see which ADO versions are available (for instance, you may see any combination or all of:
ADO 2.0, 2.1, 2.5, 2.6, 2.7
You shouldn't really see any earlier versions now-a-days.
But the easiest way is to look in a VB project under PROJECT|REFERENCES and see which ADO versions are available (for instance, you may see any combination or all of:
ADO 2.0, 2.1, 2.5, 2.6, 2.7
You shouldn't really see any earlier versions now-a-days.
- Thread starter
- #5
ADoozer: Yes, that is the one, and it will give the highest version installed, and the tlb's (msado*.tlb) will also show which other versions are also available (you can check the version file to see the exact service pack version).
I'm not too impressed with the Component Checker as is seems to only work correctly on systems set in the English language.
- Status
Similar threads
