0

利用ODBC连接MySQL

Posted in MySQL, PHP at 六月 25th, 2008 / No Comments »

http://www.connectionstrings.com/
MyODBC
 
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;
 
This one is used with eInfoDesigns dbProvider, an add-on to .NET >>
  COPY TO CLIPBOARD
SevenObjects MySqlClient (.NET)
 
Standard
 
Host=myServerAddress;UserName=myUsername;Password=myPassword;Database=myDataBase;
 
This is a freeware ADO.Net data provider from SevenObjects >>
  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=”"”";
 
This is a free simple .NET compliant MySQL driver.

Published in MySQL, PHP
Tags:

No Responses to “利用ODBC连接MySQL”

Leave a Reply

请输入算式结果(看不清请点击图片)
(必须)