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
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()
解决方案 »
- 求完美实现的ListView,后台代码数据绑定,分页,排序。
- 如何获取用户控件中treeview的selectednode
- 急求ASP.NET中tab页面切换问题
- 正则表达式--搜索一个网页中所有的连接的问题
- 关于ASP.NET 中 Attributes 的问题。
- 在ASP.NET里如何创建文件夹共享?
- 关于Request.Form的问题,高手们请帮忙看看!
- 问题已解决散分!!asp.net 调用PB做的DLL异常现象[急求解!]
- 如何提取第三条记录
- 如何在页面内容显示之前,先显示“正在加载”之类的信息
- 用js如何实现打开客户端的应用程序(如word.exe文件),谢谢高手了
- 这样的语句也会出错?????????
This one is used with eInfoDesigns dbProvider, an add-on to .NET
在用 using ....
...
MySQLConnection myConn=new MySQLConnection();
...也不清楚该using那个类。
编译是报错:缺少 using 指令或程序集引用
using System.Data;
如果是ODBC
using System.Data.ODBC;
如果是OLEDB
using System.Data.OleDb;
可是各位都没答到点上,点数就平分啦。