> Hi all
> Can anybody tell me how I can get ODBC Connection Pooling to actually
work?
> I am using the Microsoft ODBC for Oracle Driver Version 2.573.3711.00 and
> Oracle 8.0.5 database.  I went to the WinNT ODBC Datasource Administrator
> and selected the Connection Pooling Tab. I then selected this driver and
> turned on connection pooling and for the time that unused connections
remain
> in the pool, I specified 60 seconds.  Then I also enabled it for use in
the
> perfmon.  When I look at the the performance monitor, I see no activity,
> even though I have 30 simeltaneous client machines connecting with the
same
> connect string and disconnecting rapidly.

> Any ideas?
> -Beth

> Okay, this is weird.
> Connection pooling seems to be working from my VFP components, but not
from
> my VB components using ADO 2.1.  Is this an ADO 2.1 problem?
> -Beth

> > Hi all
> > Can anybody tell me how I can get ODBC Connection Pooling to actually
> work?
> > I am using the Microsoft ODBC for Oracle Driver Version 2.573.3711.00
and
> > Oracle 8.0.5 database.  I went to the WinNT ODBC Datasource
Administrator
> > and selected the Connection Pooling Tab. I then selected this driver and
> > turned on connection pooling and for the time that unused connections
> remain
> > in the pool, I specified 60 seconds.  Then I also enabled it for use in
> the
> > perfmon.  When I look at the the performance monitor, I see no activity,
> > even though I have 30 simeltaneous client machines connecting with the
> same
> > connect string and disconnecting rapidly.

> > Any ideas?
> > -Beth

> Beth,
> Make sure to read the following article:

> Pooling in the Microsoft Data Access Components
> http://msdn.microsoft.com/library/techart/pooling2.htm

> --

> Thanks,
> Carl Prothman, MVP, CCP
> http://www.able-consulting.com
> Share what you know. Learn what you don't.

> > Okay, this is weird.
> > Connection pooling seems to be working from my VFP components, but not
> from
> > my VB components using ADO 2.1.  Is this an ADO 2.1 problem?
> > -Beth

> > > Hi all
> > > Can anybody tell me how I can get ODBC Connection Pooling to actually
> > work?
> > > I am using the Microsoft ODBC for Oracle Driver Version 2.573.3711.00
> and
> > > Oracle 8.0.5 database.  I went to the WinNT ODBC Datasource
> Administrator
> > > and selected the Connection Pooling Tab. I then selected this driver
and
> > > turned on connection pooling and for the time that unused connections
> > remain
> > > in the pool, I specified 60 seconds.  Then I also enabled it for use
in
> > the
> > > perfmon.  When I look at the the performance monitor, I see no
activity,
> > > even though I have 30 simeltaneous client machines connecting with the
> > same
> > > connect string and disconnecting rapidly.

> > > Any ideas?
> > > -Beth