数据库连接字符串大全 之 SQL服务器篇

数据库的连接字符串经常使用，可是数据库的种类繁多，连接方式又分很多种，下面提供各个数据库各种方式的连接字符串方便使用的时候查询。   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;

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;

Core Labs OraDirect (.NET) Data Shape