MySQL Connector/Net
Standard
| Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
| MySQL
Specifying TCP port
| Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;
| Pwd=myPassword;
MySQLDriverCS
| Location=myServerAddress;Data Source=myDataBase;User ID=myUsername;
| Password=myPassword;Port=3306;Extended Properties="""";
SevenObjects MySqlClient
| Host=myServerAddress;UserName=myUsername;Password=myPassword;Database=myDataBase;
dotConnect for MySQL (former MyDirect.NET and Core Labs MySQLDirect.NET)
| User ID=root;Password=myPassword;Host=localhost;Port=3306;Database=myDataBase;
| Direct=true;Protocol=TCP;Compress=false;Pooling=true;Min Pool Size=0;
| Max Pool Size=100;Connection Lifetime=0;
MySQL OLEDB
| Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;
.NET Framework Data Provider for OLE DB
| Provider=any oledb provider's name;OledbKey1=someValue;OledbKey2=someValue;
MySQL Connector/ODBC 5.1
Local database
| Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=myDataBase;
| User=myUsername;Password=myPassword;Option=3;
On 64 bit machine
It seems we need to point on MSDASQL for the (32 bit) ODBC driver to work on 64 bit machines.
| Provider=MSDASQL;Driver={MySQL ODBC 5.1 Driver};Server=localhost;
| Database=myDataBase;User=myUsername;Password=myPassword;Option=3;
64 bit version of the driver
Note the "w" in the driver name.
| Driver={MySQL ODBC 5.2w Driver};Server=localhost;Database=myDataBase;
| User=myUsername;Password=myPassword;Option=3;
Remote database
| Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;Database=myDataBase;
| User=myUsername;Password=myPassword;Option=3;
Specifying TCP/IP port
| Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;Port=3306;
| Database=myDataBase;User=myUsername;Password=myPassword;Option=3;
MySQL Connector/ODBC 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=myServerAddress;Database=myDataBase;
| User=myUsername;Password=myPassword;Option=3;
Specifying TCP/IP port
| Driver={MySQL ODBC 3.51 Driver};Server=myServerAddress;Port=3306;
| Database=myDataBase;User=myUsername;Password=myPassword;Option=3;
The driver defaults to port value 3306, if not specified in the connection string, as 3306 is the default port for MySQL.
MyODBC 2.50
Local database
| Driver={mySQL};Server=localhost;Option=16834;Database=myDataBase;
Remote database
| Driver={mySQL};Server=myServerAddress;Option=131072;Stmt=;Database=myDataBase;
| User=myUsername;Password=myPassword;
Specifying TCP/IP port
| Driver={mySQL};Server=myServerAddress;Port=3306;Option=131072;Stmt=;
| Database=myDataBase;User=myUsername;Password=myPassword;
The driver defaults to port value 3306, if not specified in the connection string, as 3306 is the default port for MySQL.
