MDAC version | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

MDAC version

Hi there, How can I find out what is MDAC version on my sql-Server? Thanks,
I found the answer. I write here if you like to know:
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 key:
HKEY_LOCAL_MACHINESoftwareMicrosoftDataAccessFullInstallVer 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_MACHINESoftwareMicrosoftDataAccess 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.

If not you can download COMCHEC utility to ensure the correct version. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Or you could just check the version on the following file:
C:program FilesCommon FilesSystemadomsado15.dll
]]>