Which MDAC version is installed

  • Team,

    How can I determine which MDAC version is installed on a particular client machine?



    Bye
    Gabor

  • Go to registry -> under HKEY_CLASS_ROOT

    you will see ADODB.Connection 2.5

    ADODB.Connection 2.6

    ADODB.Connection 2.7

    If you see last 2.7 that means you got MDAC 2.7. I think there is a better way find out but i don't know.

     

  • Just look at program files\common files\system\ado\msado15.dll version,

    first 3 digits are version, i.e 2.50 = MDAC 2.5, 2.51 = MDAC 2.5 SP1, etc…

     

    franco

  • Hi,

    Try this

    EXEC master..xp_regread

    N'HKEY_LOCAL_MACHINE',

    N'Software\Microsoft\DataAccess',

    N'Version'


    Balaji

  • Microsoft provide a tool to identify the MDAC version. Download the MS component checker from http://www.microsoft.com/downloads/details.aspx?familyid=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en

     

    Steven

  • I have to agree with Steven that the component checker is the best way to verify and troubleshoot clients.  Different installs of various products can alter MDAC installations and this tool will thoroughly check all installed components against the release version that you choose.  It's saved me a lot of time and trouble in the past, and the latest release of this tool runs quite a bit faster than the older versions.  Best of luck.

    My hovercraft is full of eels.

  • Thanks to everybody. Nice and quick help



    Bye
    Gabor

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply