Blade Watch

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

Related posts:

1. More information on Windows Server 2008 Foundation RCP The new server is called Windows Server 2008 Foundation....
2. Allow file types in SharePoint http://technet.microsoft.com/en-us/library/cc288335.aspx Microsoft Windows SharePoint Services provides the ability to restrict...
3. Microsoft Vista Service Pack 2 available for download Microsoft Vista Service Pack 2 has been released, I’m off...
4. Microsoft Patches for September http://www.microsoft.com/technet/security/bulletin/ms09-sep.mspx This bulletin summary lists security bulletins released for September...
5. Microsoft Windows 7 and Internet Explorer Guardian European versions of Microsoft’s new Windows 7 operating will...

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