Re: ODBC Connection Pooling & Oracle

"Jennifer" <Jennifer_at_DAG[DELETEME].ca> wrote in message news:<HbRa9.10174$V21.212590_at_news>...
> Hello All,
> Does anyone know of any Server side parameters that could be set in the
> sqlnet.ora or init.ora that would disable ODBC connections pooling?

Assuming that you're using the Oracle ODBC driver (I assume the same goes for the Microsoft driver), no server side parameters could possibly interfere with ODBC connection pooling.

> I've been working on a project for months and everything seemed fine until I
> moved the application to the client site. It seems to take a really long
> time to just connect to the database through the application. Once I am in
> and execute a select statement, it returns quickly but, if I close the
> connection to the database and issue another select statement again I wait a
> long time for the connection and then eventually after the connection is
> established the record set is returned quickly.
>
> Anyone have any idea what might be going on?
> Oracle version is 8.1.6

Can you verify that connection pooling is actually turned on in the ODBC Data Source Administrator?

Justin Received on Wed Aug 28 2002 - 03:03:43 CDT