Re: ODBC Connection Pooling

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.

Beth Massi <bmassi@_NOSPAM_hmtreturn.com> wrote in message news:7mj9su$qtp_at_dfw-ixnews11.ix.netcom.com...
> 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
>
> Beth Massi <bmassi@_NOSPAM_hmtreturn.com> wrote in message
> news:7mj5vo$o5b_at_dfw-ixnews11.ix.netcom.com...
> > 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
> >
> >
> >
>
>
Received on Thu Jul 15 1999 - 12:55:28 CDT