Re: How to verify that the connection pooling is enabled on IIS 5.0?
From: Pat [MSFT] (patfilot_at_online.microsoft.com)
Date: 02/24/04
- Next message: Pat [MSFT]: "Re: IIS Keeps terminating"
- Previous message: Ken Schaefer: "Re: Confused about ASP, "sessions", and queuing of multiple requests"
- In reply to: Bob: "How to verify that the connection pooling is enabled on IIS 5.0?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 23 Feb 2004 22:28:57 -0800
Connection pooling is per process (i.e. each process may pool connections,
but each process gets a separate pool). The pool is handled by OLEDB.
The error you are receiving is bubbling up from the Oracle Driver. You
would need to check the Oracle documentation for the various causes of error
ORA-00020. Though, from the text, it appears to the be the maximum number
of client processes has been exceeded.
Pat
"Bob" <byuan@cga-canada.org> wrote in message
news:9AF69654-4375-4D1C-85D7-A228CF1DCF71@microsoft.com...
> We are running Windows 2000 Server sp3, with IIS 5.0, to host an ASP
application that connects to Oracle8i Database. We have Oracle9i client
installed, MDAC v.2.7, Microsoft ODBC for Oracle v.2.5, we keep geeting
error:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC driver for Oracle][Oracle]ORA-00020: maximum number of
processes (%s) exceeded
>
> I checked with Oracle website, no clues, I am wandering it may be the
connection pooling problem. Anyone knows how to verify the connection
pooling is enabled on IIS 5.0? if not, how to enable it?
>
> Thanks a lot.
>
> Bob
> byuan@cga-canada.org
- Next message: Pat [MSFT]: "Re: IIS Keeps terminating"
- Previous message: Ken Schaefer: "Re: Confused about ASP, "sessions", and queuing of multiple requests"
- In reply to: Bob: "How to verify that the connection pooling is enabled on IIS 5.0?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
