Re: ODBC and Oracle Connection Pooling

danl_thompson_at_hotmail.com (Dan Thompson) wrote in message news:<806b620f.0305230739.1b0fe86b_at_posting.google.com>...
>
> I have an IIS application running on a Windows 2000 box. It uses the
> Oracle ODBC driver to connect to an Oracle 8.1.7 server. The
> connection pooling tab in the ODBC setup has a retry wait time of 120.
> Perfmon is enabled. Oracle ODBC driver version on says it is "Oracle
> in ORACLE_iSetup Version 9.02.00.00"

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.

Justin  

> 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 Fri May 23 2003 - 16:29:37 CDT