各种数据库连接字符串

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;