by Gabio (9 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Mon 13th January 2003
Date Added: Mon 8th February 2021
Rating: (1 Votes)
Connect to mySql database without DSN.(However MySQL ODBC 3.51 Driver must be installed on local machine )
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
No comments have been posted about Connect to mySql database without DSN.(However MySQL ODBC 3.51 Driver must be installed on local ma. Why not be the first to post a comment about Connect to mySql database without DSN.(However MySQL ODBC 3.51 Driver must be installed on local ma.