MYSQL Database Connection String

OLE DB, OleDbConnection (.NET)

Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;

MySQL Connector/ODBC 3.51 (MyODBC 3.51)

Local database
Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3;

Remote database
Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;

Specifying TCP/IP port
Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;Port=3306;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;