Find it hard to remember database connection strings in Ado.Net ? You are not alone! Here is an easy-to-use reference of connection strings for My Sql. In Ado.Net we can make connection to MySql in different ways.
// ODBC -- MyODBC Driver -- remote database
using System.Data.Odbc;
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = "Driver={MySql}; Server=db.domain.com; Option=131072; Port=3306; Stmt=; DataBase=DataBaseName; Uid=UserName; Pwd=Secret;" ;
conn.Open();
// OleDb using System.Data.OleDb; OleDbConnection conn = new OleDbConnection(); conn.ConnectionString = "Provider=MySqlProv; Data Source=ServerName; User id=UserName; Password=Secret"; conn.Open();
// .NET DataProvider from CoreLab using CoreLab.MySql; MySqlConnection conn = new MySqlConnection(); conn.ConnectionString ="Host=ServerName; DataBase=DataBaseName; Protocol=TCP; Port=3306; Direct=true; Compress=false; Pooling=true; Min Pool Size=0; Max Pool Size=100; Connection Lifetime=0; User id=UserName;Password=Secret"; conn.Open();