oracle 连接方式

Oracle	Set your custom connection string values »
This is a compiled connection strings reference list on how to connect to Oracle.
ODBC
New version
Driver= {Microsoft ODBC for Oracle}; Server= myServerAddress; Uid= myUsername; Pwd= myPassword;
Old version
Driver= {Microsoft ODBC Driver for Oracle}; ConnectString= OracleServer.world; Uid= myUsername; Pwd= myPassword;
OLE DB, OleDbConnection (.NET)
Standard security
This connection string uses a provider from Microsoft.
Provider= msdaora; Data Source= MyOracleDB; User Id= myUsername; Password= myPassword;
Trusted connection
Provider= msdaora; Data Source= MyOracleDB; Persist Security Info= False; Integrated Security= Yes;
Standard Security
This connection string uses a provider from Oracle.
Provider= OraOLEDB.Oracle; Data Source= MyOracleDB; User Id= myUsername; Password= myPassword;
Trusted Connection
Provider= OraOLEDB.Oracle; Data Source= MyOracleDB; OSAuthent= 1;
Oracle.DataAccess.Client.OracleConnection
Standard
Data Source= TORCL; User Id= myUsername; Password= myPassword;
Using integrated security
Data Source= TORCL; Integrated Security= SSPI;
Using ODP.NET without tnsnames.ora
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
Standard
Data Source= MyOracleDB; Integrated Security= yes;
This one works only with Oracle 8i release 3 or later
Specifying username and password
Data Source= MyOracleDB; User Id= myUsername; Password= myPassword; Integrated Security= no;
This one works only with Oracle 8i release 3 or later Missing the System.Data.OracleClient namespace? Download .NET Managed Provider for Oracle >> Great article! "Features of Oracle Data Provider for .NET" by Rama Mohan G. at C# Corner >>
Omiting tnsnames.ora
This is another type of Oracle connection string that doesn't rely on you to have a DSN for the connection. You create a connection string based on the format used in the tnsnames.ora file without the need to actually have one of these files on the client pc.
SERVER= (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID))); uid= myUsername; pwd= myPassword;
Some reported problems with the one above and Visual Studio. Use the next one if you've encountered problems.
Data Source= (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID))); User Id= myUsername; Password= myPassword;
Using Connection Pooling
The connection pooling service will create a new pool if it can't find any existing pool that exactly match the new connections connection string properties. If there is a matching pool a connection will be recycled from that pool.
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 Authentication
Data Source= myOracleDB; User Id= /;
Privileged Connection
With SYSDBA privileges
Data Source= myOracleDB; User Id= SYS; Password= SYS; DBA Privilege= SYSDBA;
Privileged Connection
With SYSOPER privileges
Data Source= myOracleDB; User Id= SYS; Password= SYS; DBA Privilege= SYSOPER;
Utilizing the Password Expiration functionality
First open a connection with a connection string. When the connection is opened, an error is raised because the password have expired. Catch the error and execute the OpenWithNewPassword command supplying the new password.
Data Source= myOracleDB; User Id= myUsername; Password= myPassword; oConn.OpenWithNewPassword(sTheNewPassword);
Proxy Authentication
Data Source= myOracleDB; User Id= myUsername; Password= myPassword; Proxy User Id= pUserId; Proxy Password= pPassword;
Core Labs OraDirect (.NET)
Standard
User ID= myUsername; Password= myPassword; Host= ora; Pooling= true; Min Pool Size= 0; Max Pool Size= 100; Connection Lifetime= 0;
Data Shape
MS Data Shape
Provider= MSDataShape.1; Persist Security Info= False; Data Provider= MSDAORA; Data Source= orac; User