• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Connect to mySql database without DSN.(However MySQL ODBC 3.51 Driver must be installed on local ma

Connect to mySql database without DSN.(However MySQL ODBC 3.51 Driver must be installed on local ma

Connect to mySql database without DSN.(However MySQL ODBC 3.51 Driver must be installed on local machine )

Rate Connect to mySql database without DSN.(However MySQL ODBC 3.51 Driver must be installed on local ma

• 1
• 2
• 3
• 4
• 5

(2(2 Vote))

    If port = -1 Then
' local database
        aCon.Open "Driver={MySQL ODBC 3.51 Driver};Server=" & serverName & ";Database=" & dbName & ";" & _
          "User=" & user & ";Password=" & password & ";Option=4;"
    Else
' remote database, port = 3306
        aCon.Open "Driver={MySQL ODBC 3.51 Driver};Server=" & serverName  & "Port=" & port & ";Database=" & dbName & ";" & _
          "User=" & user & ";Password=" & password & ";Option=4;"
    End If
 End Function