各种数据库连接字符串

MySQL ：

 

MySqlClient："Server=ServerAddress;Port=ServerPort;Database=DatabaseName;Uid=UserName;Pwd=Password";

                        "Server=ServerAddress;Port=ServerPort;Database=DatabaseName;Uid=UserName;Pwd=Password;Default command timeout=CommandTimeout;Connection timeout=ConnectionTimeout";

 

MySqlODBC:"Driver={BMF MySQL ODBC Driver};Server=ServerAddress;Port=ServerPort;Database=DatabaseName;Uid=UserName;Pwd=Password";

 

 

SQL Server:

 

MSSQLClient:"Data Source=ServerAddress,ServerPort;Initial Catalog=DatabaseName;User ID=UserName;Password=Password";

 

MSSqlODBC:"Driver={SQL Driver};Server=ServerAddress;Port=ServerPort;Database=DatabaseName;Uid=UserName;Pwd=Password";

 

 

Oracle:

 

Oracle Direct:  "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ServerAddress)(PORT=ServerPort)))(CONNECT_DATA=(SERVICE_NAME=ServiceName)));User Id=UserName;Password=Password";

 

Oracle TNS: "Data Source=DatabaseName;User Id=UserName;Password=Password";

 

Oracle ODBC(MS):"Driver={Microsoft ODBC for Oracle};Server=DatabaseName;Uid=UserName;Pwd=Password";

 

Oracle ODBC(OraClient):"Driver={Oracle in OraClient10g_home1};Server=ServerAddress;Dbq=DatabaseName;Uid=UserName;Pwd=Password";

 

DB2:

 

IBM.Data.DB2:"Server=ServerAddress:ServerPort;Database=DatabaseName;userid=UserId;password=Password;

 

ODBC:"DRIVER={IBM DB2 ODBC Driver};UID=UserId;PWD=Password;PROTOCOL=TCPIP;HOSTNAME=ServerAddress;DATABASE=DatabaseName;PORT=ServerPort";