ansaurus

Question

With VBA, find the version of the the MySQL ODBC driver installed in Windows

Answer 1

+3 A:

You can find it in the registry under

HKEY_LOCAL_MACHINE\SOFTWARE\
    ODBC\ODBCINST.INI\
    ODBC Drivers\MySQL ODBC 3.51 Driver


 HKEY_LOCAL_MACHINE\SOFTWARE\
    ODBC\ODBCINST.INI\
    ODBC Drivers\MySQL ODBC 5.1 Driver

Using the info found here, you can get at it using the below code (I tested it in Access 97)

Private Sub Command0_Click()    
    If RegKeyExists("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\
                                 ODBC Drivers\MySQL ODBC 3.51 Driver") Then
        MsgBox "3.51"
    ElseIf RegKeyExists("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\
                                 ODBC Drivers\MySQL ODBC 5.1 Driver") Then
        MsgBox "5.1"
    Else
        MsgBox "None"
    End If
End Sub


'returns True if the registry key i_RegKey was found
'and False if not
Function RegKeyExists(i_RegKey As String) As Boolean
    Dim myWS As Object

    On Error GoTo ErrorHandler
    'access Windows scripting
    Set myWS = CreateObject("WScript.Shell")
    'try to read the registry key
    myWS.RegRead i_RegKey
    'key was found
    RegKeyExists = True
    Exit Function

ErrorHandler:
  'key was not found
  RegKeyExists = False
End Function

Re0sless 2010-01-12 16:31:48

How can I use VBA to look at the registry at the location you specified?

Ben McCormack 2010-01-12 16:36:11

You will find script here http://stackoverflow.com/questions/2020181/find-version-of-access/2020919#2020919 for checking the registry that will work in Access.

Remou 2010-01-12 16:43:45

That script uses VB.NET, which doesn't always translate to VBA. How will it work?

Ben McCormack 2010-01-12 16:53:51

@Re0sless That worked incredibly well. Much thanks!

Ben McCormack 2010-01-12 17:27:22

Just a thought but the function checks the key exists, not the value of the key, I don't know if the key is uninstalled with the driver. so you may with to check the value of the key too. there is a function for that in the link in my answer.

Re0sless 2010-01-12 17:32:59

@Ben McCormick 'That script' does not use VB.Net, it uses VBScript, and works fine in Access. Or at least it did when I put it together :)

Remou 2010-01-12 19:34:21

The script is not using VBScript, but VBA, since it will be run within Access. As written, it would require substantial editing to run as a VBScript.

David-W-Fenton 2010-01-12 22:38:59

@DW Fenton, if you are referring to my comment, the script I refer to is in the link I posted as a comment, at that time the post above did not have any code at all. The script in the link is VBScript, I tested in both Access and VBScript when I was putting it together.

Remou 2010-01-13 01:25:44

OK -- I missed tracing things back. Probably not a good idea to use something as ambiguous as "that script" in a comment, don't you think?

David-W-Fenton 2010-01-14 02:52:50

Answer 2

+2 A:

Here are a few possible ideas:

1 You may be able to check the registry and look for specific keys, like this for example: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MySQL ODBC 3.51 Driver]

2.You could check their c:\windows\system32 folder for the myodbc.dll, and then check the version information. Here's a link on how to check the version: http://www.vb-helper.com/howto_file_version_info.html

dcp 2010-01-12 16:32:49

ansaurus

tags:

views:

answers:

With VBA, find the version of the the MySQL ODBC driver installed in Windows

related questions