Oracle connection string Summary

OracleXE standard connection OracleXE (or OracleDatabase10gExpressEdition) is a simple and free version. The following syntax is used: Driver (OracleinXEClient); dbq111.21.31.99: 1521XE; UidmyUsername; PwdmyPassword; the connection mode for new ODBC versions is as follows:

Oracle XE standard connection Oracle XE (or Oracle Database 10g Express Edition) is a simple and free release version. The following syntax is used: Driver = (Oracle in XEClient); dbq = 111.21.31.99: 1521/XE; Uid = myUsername; Pwd = myPassword; the connection mode for new ODBC versions is as follows:

Oracle XE

Standard connection

Oracle XE (or "Oracle Database 10g Express Edition") is a simple and free version.

The syntax format is as follows: Driver = (Oracle in XEClient); dbq = 111.21.31.99: 1521/XE; Uid = myUsername; Pwd = myPassword;

ODBC

Connection Mode of the new version

The syntax format is as follows: Driver = {Microsoft ODBC for Oracle}; Server = myServerAddress; Uid = myUsername; Pwd = myPassword;

Connection Mode of earlier versions

The syntax format is as follows: Driver = {Microsoft ODBC Driver for Oracle}; ConnectString = OracleServer. world; Uid = myUsername; Pwd = myPassword;

Ole db, OleDbConnection (. NET)

Standard secure connection

This connection method uses Provider from Microsoft.

The syntax format is as follows: Provider = msdaora; Data Source = MyOracleDB; User Id = myUsername; Password = myPassword;

Trusted connection

The syntax format is as follows: Provider = msdaora; Data Source = MyOracleDB; Persist Security Info = False; Integrated Security = Yes;

Standard secure connection

This connection method uses the Provider from Oracle.

The syntax format is as follows: Provider = OraOLEDB. Oracle; Data Source = MyOracleDB; User Id = myUsername; Password = myPassword;

Trusted connection

The syntax format is as follows: Provider = OraOLEDB. Oracle; Data Source = MyOracleDB; paiuthent = 1;

The syntax format is as follows: 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

Standard connection

The syntax format is as follows: Data Source = TORCL; User Id = myUsername; Password = myPassword;

Connections with integrated security

The syntax format is as follows: Data Source = TORCL; Integrated Security = SSPI;

Connection with ODP. NET Without tnsnames. ora

The syntax format is as follows: 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 connection

The syntax format is as follows: Data Source = MyOracleDB; Integrated Security = yes

Only in Oracle8i release 3 or later

Specify the connection between user password and password

The syntax format is as follows: Data Source = MyOracleDB; User Id = myUsername; Password = myPassword; Integrated Security = no;

This is another connection method that does not depend on your DNS. 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.

The syntax format is as follows: 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.

The syntax format is as follows: Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = MyHost) (PORT = MyPort) (CONNECT_DATA = (SERVICE_NAME = MyOracleSID ))); user Id = myUsername; Password = myPassword;

Use connection pool

If the connection pool service cannot find a connection that completely matches the connection string, it will create a connection. If the connection can be found, it will be used again.

The syntax format is as follows: 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 Verification

The syntax format is as follows: Data Source = myOracleDB; User Id = /;

Privileged connection

Use the SYSOPER privilege

The syntax format is as follows: Data Source = myOracleDB; User Id = SYS; Password = SYS; DBA Privilege = SYSOPER;

Use a password to terminate a function

When the connection is opened for the first time, a password expiration error is thrown after the link is opened. capture this error and run the OpenWithNewPassword command to set a new password.

The syntax format is as follows: Data Source = myOracleDB; User Id = myUsername; Password = myPassword; OConn. OpenWithNewPassword (sTheNewPassword );

Proxy Verification

The syntax format is as follows: Data Source = myOracleDB; User Id = myUsername; Password = myPassword; Proxy User Id = pUserId; Proxy Password = pPassword;

Core Labs OraDirect (. NET)

Standard connection

The syntax format is as follows: 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

The syntax format is as follows: Provider = MSDataShape.1; Persist Security Info = False; Data Provider = MSDAORA; Data Source = orac; User Id = myUsername; Password = myPassword;