Search This Blog

Tuesday, November 19, 2013

Oracle Connection strings

Oracle > Connection strings


With tnsnames.ora

Data Source=OracleDB;User Id=Username;Password=Password;
Integrated Security
=no;

Without tnsnames.ora

Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=yourHost)(PORT=yourPort))(CONNECT_DATA=(SERVICE_NAME=yourOracleSID)));
User Id=Username;Password=Password;