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()
解决方案 »
- HttpWebRequest实现模拟登陆 并抓取登陆后的页面信息
- 在类中 引用 System.Web 有什么好处?
- 没刷新一次页面就监听一次TCP端口
- 请教个更新数据的问题
- 如何做饼形图
- 做一个aspx应用程序,需要很多界面吗?怎么组织?谢谢
- webService 为什么不用iis呀?这和是否是局域网有关系吗? 搞不懂了。asp.net建站的时候得用到IIS吧?也得用到webservice 吧?
- 刚学asp.net,请教各位:
- XML如何应用到网站???高手请指点
- 水晶报表错误:在vs.net2003中找不到vsdesigner
- 用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;
可是各位都没答到点上,点数就平分啦。