Loading...

RE: Oracle connection string for SI Web parts configuration

RE: Oracle connection string for SI Web parts configuration

#5137
Anonymous
Anonymous
Participant

A sample connection string is listed below:
User ID=xxx;Password=xxx;Host=192.168.0.243;SID=orcl;Pooling=false;Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0;Direct=true;

Note if you are trying to connect to a clustered oracle instances, the connection string is different and you will need set Direct flag to false to use RAC mode to work with clustered environment. Notice that no SID is specified in the connection string.

User ID=xxx;Password=XXX;Host=company_server; Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0;Direct=false;
For more connection string settings, you may refer to http://www.connectionstrings.com/oracle.