Jaa


Checkin’ those components!!

Well, it finally happened – Component Checker 2.0 was finally posted on Microsoft.com.  I don’t know that the actual functionality is earth shattering, but it is nice to finally see it out there.

“What is Component Checker?” and “Why should I care it was updated?” are probably right on the tip of your tongue.  Wait for it, wait for it…

OK, no more teasing – Component Checker is a tool that can be used to check the state of your Microsoft Data Access Components (affectionately known as “MDAC” by those who deal with it) installation.  These components are used by all native applications to talk to various types of databases and are basically required parts of any client/server application that involves a database as the server component.  If you want to see exactly what turning of one of the core parts of MDAC does to your system, follow the workaround of unregistering OLEDB32 from MS08-078.  Good luck trying to do anything functional with data of any type!

The cool thing about the newest release of Component Checker is that is can be used to check every OS installation in existence that might have a bad MDAC installation.  This includes all the variants of XP, 2003, and 2000 (2008 and Vista are left off this list intentionally since it is almost impossible to corrupt their data access stack).  All you have to do is run Component Checker, select “Perform analysis against a selected version” and the select your version of Windows.

You should get something that looks like this:

CC2

If you installation is clean, you will see nothing but matches above. 

So, you might ask, why do I have mismatches above?  Well, for that, I go back to the reference to MS08-078 above.  Component Checker is not smart enough to know that files that are LATER than the ones it is checking for are OK.   Unfortunately, due to the bad guys out there these days, it is pretty common to find later versions of the various binaries pushed out via Windows Update.

However, it is still pretty easy to check your installation.  Just look to make sure that the Mismatch Fields column has a version number less than the Version field:

cc2-a

(click on the image above for a larger view)

As you can see above, Component Checker is looking for 2.81.1117 and I have 2.81.1135 (MSADCE) and 2.81.1124 (MSADCO).  Good to go!

Comments

  • Anonymous
    January 04, 2009
    通过上一篇博客,我们已经知道Component Checker是一个用来检查MDAC安装版本的软件。简单地说,MDAC(Microsoft Data Access Components 的简称)是微软数据库访问组件,它是Windows平台上应用程序连接和访问数据库的接口。MDAC的应用十分广泛,但是由于历史原因偶尔会遇到兼容性问题,所以使用前通常要先检查MDAC的安装版本。