Re: OracleNet and Mocrosoft COM objects

"Michael D. Long" <michael.d.long-nospam_at_comcast.net> wrote in news:6pOdnV9NC4mPBtrcRVn-tQ_at_comcast.com:

> You're being bitten by connection pooling. The algorithm doesn't
> properly release connections on errors that are non-recoverable, such
> as when communication to the server is lost.
>
> To simulate the problem, build a fat client, nail up a connection,
> begin performing queries and recycle the server. Make sure not to fix
> the connection, but continue outputting errors. You should see the
> same behavior.
>

So what's the solution? What needs to be recycled to correct the problem when it happens, and is there anything that can be done to prevent it?

-- 
Chuck
Remove "_nospam" to reply by email