Berikut connection string yang dipakai untuk MySQL
MyODBC|
|
|
Driver={mySQL};Server=localhost;Option=16834; Database=myDataBase; |
|
|
|
|
Driver={mySQL};Server=myServerAddress; Port=3306;Option=131072;Stmt=; Database=myDataBase;Uid=myUsername;Pwd=myPassword; |
|
|
|
|
Driver={MySQL ODBC 3.51 Driver};Server=localhost; Database=myDataBase;User=myUsername; Password=myPassword;Option=3; |
|
|
|
|
Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com; Port=3306;Database=myDataBase;User=myUsername; Password=myPassword;Option=3; |
|
OLE DB, OleDbConnection (.NET)|
|
|
Provider=MySQLProv;Data Source=mydb; User Id=myUsername;Password=myPassword; |
|
Connector/Net 1.0 (.NET)|
|
|
Server=myServerAddress;Database=myDataBase; Uid=myUsername;Pwd=myPassword; |
|
|
|
|
Server=myServerAddress;Port=1234; Database=myDataBase;Uid=myUsername; Pwd=myPassword; |
|
|
|
|
Server=myServerAddress;Port=-1; Database=myDataBase;Uid=myUsername; Pwd=myPassword; |
|
MySqlConnection (.NET)|
|
|
Data Source=myServerAddress;Database=myDataBase; User ID=myUsername;Password=myPassword;Command Logging=false; |
|
|
SevenObjects MySqlClient (.NET)|
|
|
Host=myServerAddress;UserName=myUsername; Password=myPassword; Database=myDataBase; |
|
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; |
|
MySQLDriverCS (.NET)|
|
|
Location=myServerAddress;Data Source=myDataBase; User ID=myUsername;Password=myPassword; Port=3306;Extended Properties=""""; |
|
No comments:
Post a Comment