My ODBC driver for new MySQL version 5.2

[dinotom]

I just upgraded to MySQL Connector/ODBC 5.2 from 5.1 and now my db connections don't work as I have wrong driver text in my functions. I've gone to their site and Googled for it but I cannot find it. Does anyone know what the new driver string is?

This is the code I used successfully before, I need a new DRIVER string for version 5.2. Any help appreciated

Public Sub ConnectDB(server As String, user As String, password As String, Optional Database As String, Optional testmode As Boolean)
    On Error GoTo ErrHandler
    Set oConn = New ADODB.Connection
        oConn.Open "DRIVER={MySQL ODBC 5.1 Driver};" & _
         "SERVER=" & server & ";" & _
         "DATABASE=" & Database & ";" & _
         "USER=" & user & ";" & _
         "PASSWORD=" & password & ";" & _
         "Option=3"


    If testmode = True Then
        MsgBox "Database Connection Test Successful!", vbInformation, "Success!"
        'cmdInsertData.Enabled = True
    End If
    Exit Sub
ErrHandler:
    MsgBox Err.Description, vbCritical, Err.Source
End Sub

 

[ukmikeb]

Hi

Hope this helps:-
MySQL :: MySQL Connector/ODBC 5.2.4 has been released

 

[dinotom]

Yes, I know and that is what I upgraded to. But I need to know what part of this Driver string changed so that excel can communicate with mysql via odbc with this connector.

old string that works with prior connector version oConn.Open "DRIVER={MySQL ODBC 5.1 Driver};"
new string for version 5.2 oConn.Open "Driver={ ? };"

 

[Andrew Poulsom]

Did you try changing 5.1 to 5.2?

 

[dinotom]

yes and get the same error. I even went back and removed the new connector and re-installed the old one and am now getting the same error!

 

[Andrew Poulsom]

Maybe it's {MySQL ODBC 5.2w Driver}.

 

[dinotom]

I tried all those variations still getting this error
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

 

[Norie]

Thomas

Which version did you install, the 32 bit or 64 bit?

I originally tried with the 64 bit but experienced the problems you described.

I then installed the 32 bit version and ran this code without problems.

Private Sub GetTheWorld()

Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim fld As ADODB.Field
Dim strConn As String
Dim sql As String


    Set conn = New ADODB.Connection

    strConn = "DRIVER={MySQL ODBC 5.2a Driver};"
    strConn = strConn & "SERVER=localhost;"
    strConn = strConn & "DATABASE=World;"
    strConn = strConn & "UID=userid;PWD=password"

    conn.ConnectionString = strConn
    
    conn.Open

    sql = "SELECT * FROM country;"
    Set rs = New ADODB.Recordset
    rs.Open sql, conn


    Range("A1").CopyFromRecordset rs

    Set rs = Nothing
    Set conn = Nothing

End Sub