no special support from microsoft, you have to use System.Data.Odbcbut see Fully managed ADO.Net drivers for MySql and PostgreSQL http://sourceforge.net/projects/mysqlnet/Exploring MySQL in the Microsoft .NET Environment http://www.mysql.com/articles/dotnet/
可以,你可以参考一下下面的资料: MySQL
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;" OLEDB, OleDbConnection (.NET)
Standard: "Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;" MySqlConnection (.NET) EID: "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 EID.MySqlClient; MySqlConnection oMySqlConn = new MySqlConnection(); oMySqlConn.ConnectionString = "my connectionstring"; oMySqlConn.Open(); VB.NET: Imports EID.MySqlClient Dim oMySqlConn As MySqlConnection = New MySqlConnection() oMySqlConn.ConnectionString = "my connectionstring" oMySqlConn.Open()
如果你要使用ODBC对MySQL进行连接,你可以到MS的网站上下载一个ODBC for NET 的数据提供者。这样你在进行数据连接时就方便多了。 用OLE进行连接,没试过。
Fully managed ADO.Net drivers for MySql and PostgreSQL
http://sourceforge.net/projects/mysqlnet/Exploring MySQL in the Microsoft .NET Environment
http://www.mysql.com/articles/dotnet/
MySQL
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;"
OLEDB, OleDbConnection (.NET)
Standard:
"Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;"
MySqlConnection (.NET)
EID:
"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 EID.MySqlClient;
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "my connectionstring";
oMySqlConn.Open(); VB.NET:
Imports EID.MySqlClient
Dim oMySqlConn As MySqlConnection = New MySqlConnection()
oMySqlConn.ConnectionString = "my connectionstring"
oMySqlConn.Open()
用OLE进行连接,没试过。