数据库连接字符串整理

SQL服务器 ODBC连接方式 
标准安全连接 
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; 
信任连接 
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Trusted_Connection=Yes; 
提示输入用户名和密码方式 
这个有一点问题，首先你需要设置一个Prompt 属性等于adPromptAlways连接对象，然后在使用连接字符串 
oConn.Properties("Prompt") = adPromptAlways 
Driver={SQL Server};Server=myServerAddress;Database=myDataBase; 
OLE DB, OleDbConnection 连接方式(.NET) 
标准安全连接 
Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword; 
信任连接 
Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI; 
指定服务器的连接 
Provider=sqloledb;Data Source=myServerName\theInstanceName;Initial Catalog=myDataBase;Integrated Security=SSPI; 
提示输入用户名和密码方式 
oConn.Provider = "sqloledb" 
oConn.Properties("Prompt") = adPromptAlways 
Data Source=myServerAddress;Initial Catalog=myDataBase; 
通过IP地址连接 
这里的Data Source=190.190.200.100,1433 前面的190.190.200.100是IP地址，1433连接是端口 
Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
 SqlConnection连接方式 (.NET) 
标准安全连接 
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword; 
标准安全另外一种连接写法 
Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False; 
信任连接 
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI; 
信任连接另外一种连接写法 
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True; 
指定服务器的连接 
Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=True; 
对CE设备的信任连接 
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;User ID=myDomain\myUsername;Password=myPassword; 
通过IP地址连接 
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword; 
指定包大小的连接 
默认情况下， SQL服务器的微软.NET框架数据提供者设置网络包大小对8192个字节。然而这不一定是最好的，你可以根据你觉的合适的包大小设置包的大小，Packet Size= 就是设置包的大小值 
Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;Packet Size=4096;
 
Data Shape连接方式 
MS Data Shape 
Provider=MSDataShape;Data Provider=SQLOLEDB;Data Source=myServerAddress;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword; 
MySQL 
MyODBC连接方式 
MyODBC 2.50本地数据库 
Driver={mySQL};Server=localhost;Option=16834;Database=myDataBase; 
MyODBC 2.50远程数据库 
Driver={mySQL};Server=myServerAddress;Port=3306;Option=131072;Stmt=; Database=myDataBase;Uid=myUsername;Pwd=myPassword; 
MyODBC 3.51本地数据库 
Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3; 
MyODBC 3.51远程数据库 
Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;Port=3306;Database=myDataBase;User=myUsername; Password=myPassword;Option=3; 
OLE DB, OleDbConnection连接方式(.NET) 
标准连接 
Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword; 
Connector/Net 1.0连接方式(.NET) 
标准连接 
默认端口是3306 
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; 
指定端口 
Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword; 
命名管道 
如果端口号为 -1 就是告诉驱动使用命名管道协议 
Server=myServerAddress;Port=-1;Database=myDataBase;Uid=myUsername;Pwd=myPassword; 
MySqlConnection连接方式(.NET) 
eInfoDesigns.dbProvider 
Data Source=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Command Logging=false; 
SevenObjects MySqlClient连接方式(.NET) 
标准连接 
Host=myServerAddress;UserName=myUsername;Password=myPassword;Database=myDataBase; 
Core Labs MySQLDirect连接方式 (.NET) 
标准连接 
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; 
MySQLDriverCS 连接方式(.NET) 
标准连接 
Location=myServerAddress;Data Source=myDataBase;User ID=myUsername;Password=myPassword;Port=3306;Extended Properties="""";
 
Oracle 
Oracle XE 
标准连接 
Oracle XE (或 "Oracle Database 10g Express Edition")是自由分布的简化版本 
Driver=(Oracle in XEClient);dbq=111.21.31.99:1521/XE;Uid=myUsername;Pwd=myPassword;ODBC 
新版本 
Driver={Microsoft ODBC for Oracle};Server=myServerAddress;Uid=myUsername;Pwd=myPassword; 
旧版本 
Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword; 
OLE DB, OleDbConnection (.NET) 
标准安全连接(微软提供) 
Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword; 
被信任连接(微软提供) 
Provider=msdaora;Data Source=MyOracleDB;Persist Security Info=False;Integrated Security=Yes; 
标准安全连接(Oracle提供) 
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword; 
被信任连接(Oracle提供) 
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1; 
TNS-less连接 
Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myHost)(PORT=myPort)))(CONNECT_DATA=(SID=MyOracleSID)(SERVER=DEDICATED)));User Id=myUsername;Password=myPassword; 
Oracle.DataAccess.Client.OracleConnection 
标准连接 
Data Source=TORCL;User Id=myUsername;Password=myPassword; 
综合的安全连接 
Data Source=TORCL;Integrated Security=SSPI; 
没有tnsnames.ora的ODP.NET连接 
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword; 
OracleConnection, Oracle Data Provider, ODP.NET, System.Data.OracleClient.OracleConnection 
标准连接 
这个方式只适合Oracle 8i release 3或者之后的版本 
Data Source=MyOracleDB;Integrated Security=yes; 
指定用户名和密码的连接 
这个方式只适合Oracle 8i release 3或者之后的版本 
Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Integrated Security=no;省去tnsnames.ora的连接 
SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));uid=myUsername;pwd=myPassword; 
在Visual Studio中使用上面的字符串如果出现问题，就使用下面这个连接字符串 
Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword; 
使用共用连接 
Data Source=myOracleDB;User Id=myUsername;Password=myPassword;Min Pool Size=10;Connection Lifetime=120;Connection Timeout=60;Incr Pool Size=5;Decr Pool Size=2; 
Windows认证的连接 
Data Source=myOracleDB;User Id=/; 
特许连接 
SYSDBA 特许 
Data Source=myOracleDB;User Id=SYS;Password=SYS;DBA Privilege=SYSDBA; 
SYSOPER 特许 
Data Source=myOracleDB;User Id=SYS;Password=SYS;DBA Privilege=SYSOPER; 
运用密码失效功能的连接 
首先会打开连接，如果因为密码失效而提示错误的时候，就会使用OpenWithNewPassword中指定的新密码 
Data Source=myOracleDB;User Id=myUsername;Password=myPassword; 
oConn.OpenWithNewPassword(sTheNewPassword); 
代理验证连接 
Data Source=myOracleDB;User Id=myUsername;Password=myPassword;Proxy User Id=pUserId;Proxy Password=pPassword;