mySql数据库连接用的是什么？？？

handsomelove 2008-02-16 06:27:44

mySql数据库连接用的是什么？？？给代码。。。谢谢。。

...全文

69 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

handsomelove 2008-02-29

打赏
举报

谢谢。。。。

liangCK 2008-02-16

打赏
举报

解决了.请结帖.谢谢.

liangCK 2008-02-16

打赏
举报

MyODBC 2.50 Local database 

  

Driver={mySQL};Server=localhost;Option=16834;Database=myDataBase; 

 

  COPY TO CLIPBOARD 

MyODBC 2.50 Remote database 

  

Driver={mySQL};Server=myServerAddress;Port=3306;Option=131072;Stmt=; Database=myDataBase;Uid=myUsername;Pwd=myPassword; 

 

  COPY TO CLIPBOARD 

MyODBC 3.51 Local database 

  

Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3; 

 

  COPY TO CLIPBOARD 

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; 

 

  COPY TO CLIPBOARD 

OLE DB, OleDbConnection (.NET) 

 

Standard 

  

Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword; 

 

  COPY TO CLIPBOARD 

Connector/Net 1.0 (.NET) 

 

Standard 

  

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; 

 

Default port is 3306.  

  COPY TO CLIPBOARD 

Specifying port 

  

Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword; 

 

Download the driver at MySQL Developer Zone >> 

  COPY TO CLIPBOARD 

Named pipes 

  

Server=myServerAddress;Port=-1;Database=myDataBase;Uid=myUsername;Pwd=myPassword; 

 

It is the port value of -1 that tells the driver to use named pipes network protocol. 

  COPY TO CLIPBOARD 

MySqlConnection (.NET) 

 

eInfoDesigns.dbProvider 

  

Data Source=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Command Logging=false; 

 

  COPY TO CLIPBOARD 

SevenObjects MySqlClient (.NET) 

 

Standard 

  

Host=myServerAddress;UserName=myUsername;Password=myPassword;Database=myDataBase; 

 

  COPY TO CLIPBOARD 

Core Labs MySQLDirect (.NET) 

 

Standard 

  

User ID=root;Password=myPassword;Host=localhost;Port=3306;Database=myDataBase; Direct=true;Protocol=TCP;Compress=false;Pooling=true;Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0; 

 

Read more at Core Lab >> 

And on the product page >> 

  COPY TO CLIPBOARD 

MySQLDriverCS (.NET) 

 

Standard 

  

Location=myServerAddress;Data Source=myDataBase;UserID=myUsername;Password=myPassword;Port=3306;Extended Properties="""";