Re: ODP .Net Connection Pool Problem on Web Application

Sorry, I meant to also add that you need to make sure all your connections are opened/used/closed similar to this pattern so that you'll always close connections even if there are unexpected exceptions:

OracleConnection oc = null;
try
{

   oc = new OracleConnection(_myConnStr);    oc.Open();
   ...
}
catch
{

    ...log and/or reraise
}
finally
{

    if(oc != null)
    {

         oc.Close();
    }
} Received on Mon Feb 13 2006 - 16:33:32 CST