下面是使用此类库操作MySql的一个例子 //对DataSet进行操作 Public Shared Function MyODBCDataset(ByVal ReqSQL As String, _ ByVal LaBase As String, ByVal Server As String, _ ByVal Password As String, ByVal User As String, _ ByVal NomDataSet As String) As DataSet ' Connexion à un server MySQL 'avec le Driver ODBC 3.51 avec requette qui renvoie un dataset Dim MyConString As String = _ "DRIVER={MySQL ODBC 3.51 Driver};SERVER=" & Server _ & ";DATABASE=" & LaBase & ";UID=" & User _ & ";PASSWORD=" & Password & ";OPTION=3;"
using EID.MySqlClient; 这个也不行
我在网上找的这个好像不行 using eInfoDesigns.dbProvider.MySqlClient; 使用这个要下个东西,在那里可以下载?
USING SYSTEM.DATA.OLEDB;STRCONN="Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;"
www.mysql.com上有提供.net连接的驱动下载
我在网上找的这个好像不行 using eInfoDesigns.dbProvider.MySqlClient; 使用这个要下个东西,在那里可以下载?我打开好多连接都为空(不可访问)
我用的就是mysql与.net 可以用odbc来链接 The ODBC.NET Solution - MyODBC Driver ODBC provides a solution for having a complete interoperable application, as ODBC is the industry standard for accessing any database. MyODBC is the MySQL ODBC Driver, and can be used in the .NET environment for accessing MySQL through ODBC.NET. The ODBC .NET Data Provider is an add-in component (`Microsoft.Data.Odbc.dll') for the Microsoft?.NET Framework. This provider directly accesses native Open Database Connectivity (ODBC) drivers. You can get the latest ODBC.NET provider from: http://www.microsoft.com/downloads/release.asp?ReleaseID=35715. install MySQL ODBC Driver-MyODBC 3.51; and for installation instructions, refer to http://mysql.uahrc.se.ntou.edu.tw/products/myodbc/faq_2.html#Installation. Install Microsoft Data Access Components (MDAC) 2.6 or later. MDAC 2.7 is recommended. http://msdn.microsoft.com/data/Default.aspx
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=1288&lngWId=10
http://www.dotnet247.com/247reference/msgs/7/39229.aspx
http://dev.mysql.com/tech-resources/articles/dotnet/
...
网上这样的资源很多的!
:p
ByVal LaBase As String, ByVal Server As String, _
ByVal Password As String, ByVal User As String, _
ByVal NomDataSet As String) As DataSet
' Connexion à un server MySQL
'avec le Driver ODBC 3.51 avec requette qui renvoie un dataset
Dim MyConString As String = _
"DRIVER={MySQL ODBC 3.51 Driver};SERVER=" & Server _
& ";DATABASE=" & LaBase & ";UID=" & User _
& ";PASSWORD=" & Password & ";OPTION=3;"
using eInfoDesigns.dbProvider.MySqlClient;
使用这个要下个东西,在那里可以下载?
using eInfoDesigns.dbProvider.MySqlClient;
使用这个要下个东西,在那里可以下载?我打开好多连接都为空(不可访问)
可以用odbc来链接
The ODBC.NET Solution - MyODBC Driver
ODBC provides a solution for having a complete interoperable application, as ODBC is the industry standard for accessing any database. MyODBC is the MySQL ODBC Driver, and can be used in the .NET environment for accessing MySQL through ODBC.NET. The ODBC .NET Data Provider is an add-in component (`Microsoft.Data.Odbc.dll') for the Microsoft?.NET Framework. This provider directly accesses native Open Database Connectivity (ODBC) drivers. You can get the latest ODBC.NET provider from:
http://www.microsoft.com/downloads/release.asp?ReleaseID=35715. install MySQL ODBC Driver-MyODBC 3.51; and for installation instructions, refer to
http://mysql.uahrc.se.ntou.edu.tw/products/myodbc/faq_2.html#Installation.
Install Microsoft Data Access Components (MDAC) 2.6 or later. MDAC 2.7 is recommended.
http://msdn.microsoft.com/data/Default.aspx