[ASP.NET] MySQL 연결시 ConnectionString

ODBC

ODBC 2.50 Local database:

"Driver={mySQL};Server=localhost;Option=16834;Database=mydatabase;"

ODBC 2.50 Remote database:

"Driver={mySQL};Server=data.domain.com;Port=3306;Option=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;"

 ODBC 3.51 Local database:

"DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER=myUsername;PASSWORD=myPassword;OPTION=3;"

ODBC 3.51 Remote database:

"DRIVER={MySQL ODBC 3.51 Driver};SERVER=data.domain.com;PORT=3306;DATABASE=myDatabase;USER=myUsername;PASSWORD=myPassword;OPTION=3;"

OLE DB, OleDbConnection (.NET)

Standard:

"Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;"

 

MySqlConnection (.NET)

eInfoDesigns.dbProvider:

"Data Source=server;Database=mydb;User ID=username;Password=pwd;Command Logging=false" 
 

Declare the MySqlConnection:

             C#:

             using eInfoDesigns.dbProvider.MySqlClient;

             MySqlConnection oMySqlConn = new MySqlConnection();

             oMySqlConn.ConnectionString = "my connectionstring";

             oMySqlConn.Open();

 

             VB.NET:

             Imports eInfoDesigns.dbProvider.MySqlClient

             Dim oMySqlConn As MySqlConnection = New MySqlConnection()

             oMySqlConn.ConnectionString = "my connectionstring"

             oMySqlConn.Open()

 

SevenObjects MySqlClient (.NET)

Standard:

"Host=server; UserName=myusername; Password=mypassword;Database=mydb;"

Core Labs MySQLDirect (.NET)

Standard:

"User ID=root; Password=pwd; Host=localhost; Port=3306; Database=test;Direct=true; Protocol=TCP; Compress=false; Pooling=true; Min Pool Size=0;Max Pool Size=100; Connection Lifetime=0"


출처 : http://www.connectionstrings.com/