Accessing remote MySQL DBs in VB6
MySQL expert Scott Noyes recommends downloading ODBC to connect within your VB project.
MySQL supports ODBC. Download the ODBC drivers. In your VB project, add the Microsoft Remote Data Object and connect. Your connection code might look something like this:
Dim cnMySql As New rdoConnection cnMySql.CursorDriver = rdUseOdbc cnMySql.Connect = "DRIVER={MySQL ODBC 3.51 Driver};" & _ "SERVER=yourHostName;PORT=3306;" & _ "DATABASE=dbName;" & _ "UID=yourUserName;PWD=yourPassword;" & _ "OPTION=3;"Check the values for the OPTION parameter.