tNet-Tricks

Handy Dot Net Tricks Implementation !!

" Coding , A Rhythmic Literary Job "

Ado.Net - Handy Tricks, Training, Code Snippets, Reference Manual, Data Providers, Connected and Disconnected Data Access, Connection, Command, Data Set, Data Table, Data Adapter, Data Reader, Stored Procedure

MySql Connection Strings in Ado.Net

Posted By : Shailendra Chauhan, 07 Feb 2012

Updated On : 02 Mar 2012

Tags : ado.net, asp.net, .net, mysql

Today, MySql is open source database in the world. In Ado.net to make connection to MySql , we have different connection strings. Basically it is not easy to remember different database connection strings in Ado.Net. So I am sharing some connection strings to connect to the MySql database using different drivers.

Using ODBC

 // 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();

Using OLEDB

 // OleDb
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection(); 
conn.ConnectionString = "Provider=MySqlProv; Data Source=ServerName; User id=UserName; Password=Secret";
conn.Open();

Using .Net DataProvider

 // .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();

« Prev

What The ?

Trying to understand the tips and tricks? Can't find a tutorial on it? Exhausted of seeing the awe-inspiring somewhere else and not knowing how it was done?
This site will provide you the tutorial for those awesomeness tips & tricks.

Who The ?

If you're looking to learn a trick, technique you see being used somewhere else; let me know and I'll do my best to explain how it was done. If I don’t know how to do, I come across it an exciting topic; I'll find upright resources and share. More..

How The ?

Ultimately you come across something new and fresh, something you keen to learn, and the words tip out - how the heck did they do that?
Trust me, I have been there to provide all these new and fresh programming tricks. More..

Supported browsers are :