Re: ODBC and Oracle Connection Pooling

jocave_at_yahoo.com (Justin Cave) wrote in message news:<233b7a65.0305231329.4711edc_at_posting.google.com>...
> danl_thompson_at_hotmail.com (Dan Thompson) wrote in message news:<806b620f.0305230739.1b0fe86b_at_posting.google.com>...
>
> The retry wait time has nothing to do with connection pooling. It's a
> parameter that has to do with TAF (Transparent Application Failover).
>
> If you want to enable ODBC connection pooling, you need to go into the
> ODBC Data Source Administrator, go to the "Connection Pooling" tab,
> and then enable connection pooling for the Oracle ODBC driver.
>

Yes, well, the connection pooling tab SAYS it is enabled (by default) for every driver, including the Oracle driver. Yet, as far as I can tell, no ODBC connection pooling is taking place. PerfMon shows no pooled connections, the SQL queries are extremely slow, and the TNS listener on the Oracle box shows new connections. So this is still very confusing. Code sample in original posting.

Thanks, Dan
>
>
> > The ASP code gets a connection, does the query and closes the
> > connection each time. As shown here:
> >
> > dim cn
> > dim rs
> > dim cnString
> > cnString = "Provider=msdaora;" _
> > & "Data Source=ORATEST;" _
> > & UserID=ORATEST;" _
> > & Password=ORATEST;"
> >
> > Set cn = Server.CreateObject("ADODB.Connection")
> > cn.ConnectionTimeout = 15
> > cn.CommandTimeout = 30
> > cn.Open cnString
> >
> > Set rs = cn.Execute("SELECT * FROM BRAND")
> >
> > rs.MoveFirst
> > Do Until rs.EOF
> > 'yadda yadda
> > rs.MoveNext
> > Loop
> >
> > Set rs = Nothing
> >
> > cn.Close
> > Set cn = Nothing
> >
> >
> > PerfMon always shows 0 pooled ODBC connections. In fact all of the
> > ODBC perfmon data shows 0.
> >
> > The TNS Listener log on the Oracle box shows that a new connection is
> > being created each time this code runs.
> >
> > The IIS code runs very slowly, as if it were getting a new connection
> > every time.
> >
> > Any help you can provide would be... well... helpful.
> >
> > Best Regards,
> > Dan Thompson
Received on Sat May 24 2003 - 08:32:19 CDT