各位,原来我的数据库是用ACCESS的
现在得用MYSQL
原来的连接语句是Set db = OpenDatabase(App.Path + "\crmdb.mdb")
现在呢?
能否告诉我DAO中的CONNECT参数有哪些?
还有如果是使用数据源的话,上面的的语句该怎么写?谢谢
现在得用MYSQL
原来的连接语句是Set db = OpenDatabase(App.Path + "\crmdb.mdb")
现在呢?
能否告诉我DAO中的CONNECT参数有哪些?
还有如果是使用数据源的话,上面的的语句该怎么写?谢谢
ODBC
Local database:"Driver={mySQL};Server=mySrvName;Option=16834;Database=mydatabase;" Remote database:"Driver={mySQL};Server=data.domain.com;Port=3306;Option=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;" 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"
This one is used with eInfoDesigns dbProvider, an add-on to .NET
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;"
This is a freeware ADO.Net data provider from SevenObjects
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"
Read more at Core Lab and the product page.