[Database connection string] Oracle connection string

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 connection
This connection string is applicable to Microsoft drivers.
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 connection
The driver provided by Oracle.
Provider = oraoledb. Oracle; Data Source = myoracledb; user id = myusername; Password = mypassword;
Trusted connection
Provider = oraoledb. Oracle; Data Source = myoracledb; paiuthent = 1;
Oracle. dataaccess. Client. oracleconnection
Standard
Data Source = torcl; user id = myusername; Password = mypassword;
Standard secure connection
Data Source = torcl; Integrated Security = sspi;
Use ODP. net instead of 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;
For 8i RC3 and later versions
User name and password
Data Source = myoracledb; user id = myusername; Password = mypassword; Integrated Security = no;
For 8i RC3 and later versions
Ignore tnsnames. ora
Another connection method that does not require DSN.
Server = (description = (address = (Protocol = TCP) (host = myhost) (Port = myport) (CONNECT_DATA = (SERVICE_NAME = myoraclesid); uid = myusername; pwd = mypassword;
Using the above connection string may cause Visual Studio to report errors. If you encounter these problems during use, use the following connection method.
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 program cannot find an existing connection pool, it creates a new pool based on the connection string. Otherwise, the existing connection in the pool will be used cyclically.
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
Use sysdba
Data Source = myoracledb; user id = sys; Password = sys; DBA privilege = sysdba;
Privileged connection
Use sysoper
Data Source = myoracledb; user id = sys; Password = sys; DBA privilege = sysoper;
Password Expiration Process
When a "password expired" error occurs when you connect to the database using a connection string, run the openwithnewpassword command to provide the new password.
Data Source = myoracledb; user id = myusername; Password = mypassword; Oconn. openwithnewpassword (sthenewpassword );
Proxy Verification
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 id = myusername; Password = mypassword;