Connection Pool Error

Discussion in 'ASP .Net' started by Brian, Jan 10, 2004.

  1. Brian

    Brian Guest

    Hello,

    I'm having a recurring error whenever I try to debug a
    asp.net web page is retrieving data from a SQL server.
    The error msg is:

    "Timeout expired. The timeout period elapsed prior to
    obtaining a connection from the pool. This may have
    occurred because all pooled connections were in use and
    max pool size was reached."

    Any ideas?
     
    Brian, Jan 10, 2004
    #1
    1. Advertisements

  2. Brian

    Hermit Dave Guest

    by default asp.net uses pooling on connection object and a pool of 25
    objects is maintained.
    i would advise you to check for open connections....
    any errors during db call not handled (and explicitly calling con.close() )
    would not release the connection to the pool

    if you are releasing all objects and are still running out cause of the
    heavy load... try specifying the pool size in connection string...

    --
    Regards,

    HD

    "Brian" <> wrote in message
    news:00d601c3d7ba$8bef23a0$...
    > Hello,
    >
    > I'm having a recurring error whenever I try to debug a
    > asp.net web page is retrieving data from a SQL server.
    > The error msg is:
    >
    > "Timeout expired. The timeout period elapsed prior to
    > obtaining a connection from the pool. This may have
    > occurred because all pooled connections were in use and
    > max pool size was reached."
    >
    > Any ideas?
    >
     
    Hermit Dave, Jan 10, 2004
    #2
    1. Advertisements

  3. Brian

    Hermit Dave Guest

    sorry
    have a look at this article..

    http://msdn.microsoft.com/library/d...urfintroductiontoadoconnectiondesigntools.asp

    think i mixed it up with thread pool...

    --
    Regards,

    HD

    "Hermit Dave" <> wrote in message
    news:...
    > by default asp.net uses pooling on connection object and a pool of 25
    > objects is maintained.
    > i would advise you to check for open connections....
    > any errors during db call not handled (and explicitly calling

    con.close() )
    > would not release the connection to the pool
    >
    > if you are releasing all objects and are still running out cause of the
    > heavy load... try specifying the pool size in connection string...
    >
    > --
    > Regards,
    >
    > HD
    >
    > "Brian" <> wrote in message
    > news:00d601c3d7ba$8bef23a0$...
    > > Hello,
    > >
    > > I'm having a recurring error whenever I try to debug a
    > > asp.net web page is retrieving data from a SQL server.
    > > The error msg is:
    > >
    > > "Timeout expired. The timeout period elapsed prior to
    > > obtaining a connection from the pool. This may have
    > > occurred because all pooled connections were in use and
    > > max pool size was reached."
    > >
    > > Any ideas?
    > >

    >
    >
     
    Hermit Dave, Jan 11, 2004
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Sean Nolan

    Trap "connection pool" errors

    Sean Nolan, Jul 11, 2003, in forum: ASP .Net
    Replies:
    1
    Views:
    551
    David Browne
    Jul 11, 2003
  2. Simon Devlin

    How to diagnose connection pool exhaustion?

    Simon Devlin, Jan 21, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    873
    Simon Devlin
    Jan 21, 2004
  3. greg

    .NET connection pool problems

    greg, Feb 20, 2004, in forum: ASP .Net
    Replies:
    7
    Views:
    3,704
    JiangZemin
    Feb 23, 2004
  4. Linus Nikander
    Replies:
    5
    Views:
    781
  5. _XaToA_
    Replies:
    0
    Views:
    2,470
    _XaToA_
    Oct 30, 2003
  6. =?Utf-8?B?SmVycnkgSg==?=

    SQL Server connection Pool error in Debug

    =?Utf-8?B?SmVycnkgSg==?=, Apr 23, 2007, in forum: ASP .Net
    Replies:
    1
    Views:
    604
    Cowboy \(Gregory A. Beamer\)
    Apr 23, 2007
  7. Wei  Lu
    Replies:
    2
    Views:
    6,557
    Wei Lu
    Feb 16, 2009
  8. Rick Lawson
    Replies:
    8
    Views:
    1,335
    Graham Dumpleton
    Jul 17, 2009
Loading...