第一种方式.ODBC DSN
1. // ODBC DSN
2.
3. using System.Data.Odbc;
4.
5. OdbcConnection conn = new OdbcConnection();
6. conn.ConnectionString =
7. "Dsn=DsnName;" +
8. "Uid=UserName;" +
9. "Pwd=Secret;";
10. conn.Open();
第二种方式.ODBC -- MyODBC Driver -- local database
1. // ODBC -- MyODBC Driver -- local database
2.
3. using System.Data.Odbc;
4.
5. OdbcConnection conn = new OdbcConnection();
6. conn.ConnectionString =
7. "Driver={MySql};" +
8. "Server=localhost;" +
9. "Option=16834;" +
10. "DataBase=DataBaseName;"
11. conn.Open();
第三种方式.ODBC -- MyODBC Driver -- remote database
1. // ODBC -- MyODBC Driver -- remote database
2.
3. using System.Data.Odbc;
4.
5. OdbcConnection conn = new OdbcConnection();
6. conn.ConnectionString =
7. "Driver={MySql};" +
8. "Server=db.domain.com;" +
9. "Option=131072;" +
10. "Port=3306;" +
11. "Stmt=;" +
12. "DataBase=DataBaseName;" +
13. "Uid=UserName;" +
14. "Pwd=Secret;"
15. conn.Open();
第四种方式.ODBC -- MySQL ODBC 3.51 Driver
1. // ODBC -- MySQL ODBC 3.51 Driver
2.
3. using System.Data.Odbc;
4.
5. OdbcConnection conn = new OdbcConnection();
6. conn.ConnectionString =
7. "Driver={MySql ODBC 3.51 Driver};" +
8. "Server=ServerName;" +
9. "Option=16834;" +
10. "Port=3306;" +
11. "Stmt=;" +
12. "DataBase=DataBaseName;" +
13. "Uid=UserName;" +
14. "Pwd=Secret;"
15. conn.Open();
16.
17. // or
18.
19. using System.Data.Odbc;
20.
21. OdbcConnection conn = new OdbcConnection();
22. conn.ConnectionString =
23. "DRIVER={MySql ODBC 3.51 Driver};" +
24. "SERVER=ServerName;" +
25. "DATABASE=DataBaseName;" +
26. "USER=UrerName;" +
27. "PASSWORD=Secret;"
28. conn.Open();
第五种方式.OleDb
1. // OleDb
2.
3. using System.Data.OleDb;
4.
5. OleDbConnection conn = new OleDbConnection();
6. conn.ConnectionString =
7. "Provider=MySqlProv;" +
8. "Data Source=ServerName;" +
9. "User id=UserName;" +
10. "Password=Secret;"
11. conn.Open();
第六种方式.NET DataProvider from CoreLab 1.// .NET DataProvider from CoreLab 2. 3. 4. using CoreLab.MySql; 5. 6. MySqlConnection conn = new MySqlConnection(); 7. conn.ConnectionString = 8. "Host=ServerName;" + 9. "DataBase=DataBaseName;" + 10. "Protocol=TCP;" + 11. "Port=3306;" + 12. "Direct=true;" + 13. "Compress=false;" + 14. "Pooling=true;" + 15. "Min Pool Size=0;" + 16. "Max Pool Size=100;" + 17. "Connection Lifetime=0;" + 18. "User id=UserName;" + 19. "Password=Secret;" + 20. conn.Open();