Bladewatch.com

MDAC or Data Access Component which is installed?

One of the things developers often ask is the version of MDAC installed on their server, this is because the application code might have specific MDAC component calls which are dependent on that version being installed on the server. MDAC can be uninstalled, but the process is not quite add/remove programs and you are best testing an upgrade on a non production or customer facing server first. At the same point, this post is a good point to remind people that MDAC has been renamed as Windows Data Access Component in Windows 2008.

To find the version of MDAC installed, click start, run and type regedit. Now browse for the registry key under HKEY_LOCAL-MACHINE\Software\Microsoft\DataAccess

• In Windows NT4 – 2003 it will be something like 2.1 or 2.8 (dependent on which operating system and MDAC you have installed).
• For Windows 2008 – they renamed MDAC, Windows Data Access Component, the keys are the same but the first version was version 6.0

MDAC/Data Access Component links

• The Microsoft article to check MDAC versions is here – http://support.microsoft.com/kb/301202
• The history of MDAC patches can be found here – http://support.microsoft.com/kb/231943
• The Data Access Technologies Road Map is here – http://msdn.microsoft.com/en-us/library/ms810810.aspx
• The Microsoft MDAC/Data Access Component FAQ – http://msdn.microsoft.com/en-us/library/ms692877(VS.85).aspx

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.