Post reply

MDAC version

  • June 3, 2004 at 4:02 pm

    #359830

    How can I tell what version of MDAC is installed? Thank you in advance.

  • June 3, 2004 at 5:23 pm

    #508914

    May want to take a look at this site. http://support.microsoft.com/default.aspx?kbid=301202

  • June 4, 2004 at 2:31 am

    #508964

    Exactly this question is answered here



    Bye
    Gabor

  • June 4, 2004 at 11:32 am

    #509063

    Thank you!

  • June 4, 2004 at 2:48 pm

    #509092

    Here's a little stored procedure I created from a script I found on SQLServerCentral ...

    create procedure sp_MDAC

    as

    /*************************************************************/                                                                                                                                                     

    --                                                  

    -- Module Name: sp_MDAC

    --                                               

    -- Description:

    -- The purpose of this procedure is to display the current

    -- version of MDAC installed on the server.

    --                                                

    -- Written By: Steve Phelps

    --  based on original script by Parthasarathy Mandayam          

    --                                                 

    -- Date: June 4, 2004        

    --                                                  

    -- Modified :                                      

    -- Date:                                           

    --         

    --                                                 

    -- USAGE:                                           

    --

    --  exec sp_MDAC

    --                           

    /*************************************************************/  

    DECLARE @retvalue int, @data_dir varchar(500)

    EXECUTE @retvalue = master.dbo.xp_instance_regread 'HKEY_LOCAL_MACHINE',

    'SOFTWARE\Microsoft\DataAccess',

    'FullInstallVer', @param = @data_dir OUTPUT

    PRINT 'MDAC Version: '+ @data_dir

     

  • June 7, 2004 at 9:37 pm

    #509378

    You could try the following in an asp page:

    set adoConn = Server.CreateObject("ADODB.Connection")

    response.write adoConn.version

    set adoConn=nothing

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

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