Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ODBC Connection Pooling

Re: ODBC Connection Pooling

From: Beth Massi <bmassi_at__NOSPAM_hmtreturn.com>
Date: Thu, 15 Jul 1999 12:25:09 -0700
Message-ID: <7mlcbn$fb6@dfw-ixnews11.ix.netcom.com>


Thanks so much Carl!

Carl Prothman [MVP] <carlpr_at_able-consulting.com.NOSPAM> wrote in message news:e#g$Cuuz#GA.273_at_cppssbbsa02.microsoft.com...
> 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 - 14:25:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US