Forum Stats

  • 3,769,928 Users
  • 2,253,031 Discussions
  • 7,875,242 Comments

Discussions

connection pooling for OLEDB

3565194
3565194 Member Posts: 1
edited Apr 3, 2018 6:29AM in Oracle Provider for OLE DB

Hi

I am struggling to find how to configure connection pooling parameters like max and min connections for OLEDB on IBM Data centre. 

Has someone done this earlier

Answers

  • SSakthi-Oracle
    SSakthi-Oracle Member Posts: 18 Employee
    edited Apr 3, 2018 6:29AM

    <span class="key"><code><span class="key">Provider</span>=<span class="value">OraOLEDB.Oracle;</span><span class="key">Data Source</span>=<span class="value">MyOracleDB;</span><span class="key">User Id</span>=<span class="value">myUsername;</span><span class="key"><br/>Password</span>=<span class="value">myPassword;</span>Min Pool Size=10;
    Connection Lifetime=120;Connection Timeout=60;Incr Pool Size=5;Decr Pool Size=2;

This discussion has been closed.