To connect to a local databaseoConn.Open "Driver={mySQL};" & _ "Server=MyServerName;" & _ "Option=16834;" & _ "Database=mydb;"To connect to a remote databaseoConn.Open "Driver={mySQL};" & _ "Server=db1.database.com;" & _ "Port=3306;" & _ "Option=131072;" & _ "Stmt=;" & _ "Database=mydb;" & _ "Uid=myUsername;" & _ "Pwd=myPassword;"For more information, see: Programs Known to Work with MyODBC
MySQL OLE DB, OleDbConnection (.NET) Standard:"Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;"
我用的是C#.你这个是。VB.NET吗?
http://dev.mysql.com/downloads/connector/net/5.0.htmlADO.NET driver for MySQL.看看, 对你有用.
MyODBC MyODBC 2.50 Local database: "Driver={mySQL};Server=localhost;Option=16834;Database=mydatabase;" MyODBC 2.50 Remote database: "Driver={mySQL};Server=data.domain.com;Port=3306;Option=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;" MyODBC 3.51 Local database: "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER=myUsername;PASSWORD=myPassword;OPTION=3;" MyODBC 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;" Connector/Net 1.0 (.NET) Standard: "Server=Server;Database=Test;Uid=UserName;Pwd=asdasd;" Download the driver at
To connect to a local databaseoConn.Open "Driver={mySQL};" & _
"Server=MyServerName;" & _
"Option=16834;" & _
"Database=mydb;"To connect to a remote databaseoConn.Open "Driver={mySQL};" & _
"Server=db1.database.com;" & _
"Port=3306;" & _
"Option=131072;" & _
"Stmt=;" & _
"Database=mydb;" & _
"Uid=myUsername;" & _
"Pwd=myPassword;"For more information, see: Programs Known to Work with MyODBC
Standard:"Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;"
MyODBC 2.50 Local database:
"Driver={mySQL};Server=localhost;Option=16834;Database=mydatabase;"
MyODBC 2.50 Remote database:
"Driver={mySQL};Server=data.domain.com;Port=3306;Option=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;"
MyODBC 3.51 Local database:
"DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER=myUsername;PASSWORD=myPassword;OPTION=3;"
MyODBC 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;"
Connector/Net 1.0 (.NET)
Standard:
"Server=Server;Database=Test;Uid=UserName;Pwd=asdasd;"
Download the driver at
http://www.connectionstrings.com