常用数据库连接字符串

 OleDb      : Provider=Microsoft.Jet.OLEDB.4.0; Data Source=E://Database//global.mdb;
 Sql Server : server=(local);uid=sa;pwd=sa;database=testDB;timeout=120;
 Oracle     : Data Source=seaskyer;Uid=test;Pwd=test;Server=localhost;(注意：使用Oracle数据库时必须在Web服务器上安装有Oracle的客户端)
 MySql      : Driver={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=test;UID=test;PASSWORD=test;OPTION=3;(注意：使用之前必须先安装MySQL ODBC 3.51 Driver)

 

------------------------------------------------------------
MS - Access
ODBC
 Driver=Microsoft Access Driver (*.mdb); Dbq={0};
 Driver=Microsoft Access Driver (*.mdb); Dbq={0}; Uid={1}; Pwd={2};
OleDB
 // no pwd
 Provider=Microsoft.Jet.OLEDB.4.0; Data Source={0}; User ID=admin; Password=;
 // has pwd
 Provider=Microsoft.Jet.OLEDB.4.0; Data Source={0}; Jet OLEDB:Database Password={1};
 -------------------------------------------
MS -SQL Server
ODBC
 Driver=SQL Server; Server={0}; Trusted_Connection=yes; Database={1};
 Driver=SQL Server; Server={0}; Database={1}; Uid={2}; Pwd={3};
OleDB
 Provider=SQLOLEDB; Data Source={0}; Integrated Security=SSPI; Initial Catalog={1};
 Provider=SQLOLEDB; Data Source={0}; Initial Catalog={1}; User ID={2}; Password={3};
SqlClient
 Data Source={0}; Integrated Security=SSPI; Initial Catalog={1};
 Data Source={0}; Initial Catalog={1}; User ID={2}; Password={3};  
 -------------------------------------------
Oracle
ODBC
 Driver=Microsoft ODBC for Oracle;Server={0};Uid={1};Pwd={2};
OleDB
 Provider=MSDAORA;Data Source={0};User ID={1};Password={2};
OracleClient
 Data Source={0};User ID={1};Password={2};