.net problems

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Dale Hersh

    .net problems

    Hi Everyone,
    I have been using .net for a few weeks and I am getting the following two errors:

    1.
    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.

    2. Network Connection Error


    I am not sure how to get around these problems and this error does not occur everytime I use my apps. It seems to be sporadic, but does occur quite frequently. Any help would be greatly apprecaited...

    Thx.
    Dale

    ---
    Posted using Wimdows.net Newsgroups - http://www.wimdows.net/newsgroups/
  • Elsam

    #2
    RE: .net problems

    Hi,
    what kind of application are you working on. Is it an asp.net application
    model ? Is the timeout expiration problem a session expiration issue ? If
    yes, you got to cope with both catching session expiration and get
    redirecting to the login page.

    "Dale Hersh" wrote:
    [color=blue]
    > Hi Everyone,
    > I have been using .net for a few weeks and I am getting the following two errors:
    >
    > 1.
    > 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.
    >
    > 2. Network Connection Error
    >
    >
    > I am not sure how to get around these problems and this error does not occur everytime I use my apps. It seems to be sporadic, but does occur quite frequently. Any help would be greatly apprecaited...
    >
    > Thx.
    > Dale
    >
    > ---
    > Posted using Wimdows.net Newsgroups - http://www.wimdows.net/newsgroups/
    >[/color]

    Comment

    • Nick Malik

      #3
      Re: .net problems

      Hello Dale,

      I have never received this error, but it sounds to me like you have created
      an object that you are storing in a static list, and that object contains a
      connection to a database, and you are opening the connection but never
      closing it. After a while, you cannot reconnect to the database because you
      have used up the available connections in the connection pool.

      Please understand that there is no reason to keep a connection around at
      all. .NET will handle the caching for you. Simply open a connection, use
      it, and close it. If you are using C#, take a look at the "With" keyword.
      It makes error handling much easier.

      Realize that I am guessing. I may be completely off base. You have not
      provided enough information for me to be accurate. If I am wrong, I would
      be best able to provide useful input if you would give more details about
      your application. What does your app do? On what statement or call is this
      error appearing? Can you post a snippet of code where you are getting the
      error?

      --- Nick

      "Dale Hersh" <dalehersh@-NOSPAM-hotmail.com> wrote in message
      news:OQlKSkW5EH A.2572@tk2msftn gp13.phx.gbl...[color=blue]
      > Hi Everyone,
      > I have been using .net for a few weeks and I am getting the following two[/color]
      errors:[color=blue]
      >
      > 1.
      > Timeout expired. The timeout period elapsed prior to obtaining a[/color]
      connection from the pool. This may have occurred because all pooled
      connections were in use and max pool size was reached.[color=blue]
      >
      > 2. Network Connection Error
      >
      >
      > I am not sure how to get around these problems and this error does not[/color]
      occur everytime I use my apps. It seems to be sporadic, but does occur quite
      frequently. Any help would be greatly apprecaited...[color=blue]
      >
      > Thx.
      > Dale
      >
      > ---
      > Posted using Wimdows.net Newsgroups - http://www.wimdows.net/newsgroups/[/color]


      Comment

      • chanmmn

        #4
        Re: .net problems

        Step through your code and look for an infinity loop to create a connection.

        chanmm

        "Dale Hersh" <dalehersh@-NOSPAM-hotmail.com> wrote in message
        news:OQlKSkW5EH A.2572@tk2msftn gp13.phx.gbl...[color=blue]
        > Hi Everyone,
        > I have been using .net for a few weeks and I am getting the following two
        > errors:
        >
        > 1.
        > 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.
        >
        > 2. Network Connection Error
        >
        >
        > I am not sure how to get around these problems and this error does not
        > occur everytime I use my apps. It seems to be sporadic, but does occur
        > quite frequently. Any help would be greatly apprecaited...
        >
        > Thx.
        > Dale
        >
        > ---
        > Posted using Wimdows.net Newsgroups - http://www.wimdows.net/newsgroups/[/color]


        Comment

        Working...