How to Avoid Database Timeout

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Li Pang
    #1

    How to Avoid Database Timeout

    Hi,

    I have used ADO.Net to select/update/insert data from/to a MS SQL database.
    Some time when the database is busy, I received the below error:
    Timeout expired. The timeout period elapsed prior to completion of the
    operation or the server is not responding.
    Any solution for this issue?

    Thanks in advance

    Tags: None
    • Marina
      #2
      Re: How to Avoid Database Timeout

      If the server is overloaded, there is nothing you can do here but upgrade
      the server to a more powerful machine. Either that, or try to optimize the
      queries being run by whatever other application is tying up the server (if
      that is something you have access to).

      "Li Pang" <LiPang@discuss ions.microsoft. com> wrote in message
      news:8609E5E9-9FDF-4063-A311-0E6C6B32E607@mi crosoft.com...[color=blue]
      > Hi,
      >
      > I have used ADO.Net to select/update/insert data from/to a MS SQL[/color]
      database.[color=blue]
      > Some time when the database is busy, I received the below error:
      > Timeout expired. The timeout period elapsed prior to completion of the
      > operation or the server is not responding.
      > Any solution for this issue?
      >
      > Thanks in advance
      >[/color]


        Comment

        • ToddT
          #3
          Re: How to Avoid Database Timeout

          increase the time out value in the connection string?


          On Wed, 11 Aug 2004 06:25:01 -0700, "Li Pang"
          <LiPang@discuss ions.microsoft. com> wrote:
          [color=blue]
          >Hi,
          >
          >I have used ADO.Net to select/update/insert data from/to a MS SQL database.
          >Some time when the database is busy, I received the below error:
          >Timeout expired. The timeout period elapsed prior to completion of the
          >operation or the server is not responding.
          >Any solution for this issue?
          >
          >Thanks in advance[/color]

            Comment

            • 4city
              #4
              Re: How to Avoid Database Timeout

              Please seach "ADO.NET timeout" posted by 4City.

              You set the command timeout ( which is diefferent from connection timeout)
              instead of the connection timeout.



              "ToddT" wrote:
              [color=blue]
              > increase the time out value in the connection string?
              >
              >
              > On Wed, 11 Aug 2004 06:25:01 -0700, "Li Pang"
              > <LiPang@discuss ions.microsoft. com> wrote:
              >[color=green]
              > >Hi,
              > >
              > >I have used ADO.Net to select/update/insert data from/to a MS SQL database.
              > >Some time when the database is busy, I received the below error:
              > >Timeout expired. The timeout period elapsed prior to completion of the
              > >operation or the server is not responding.
              > >Any solution for this issue?
              > >
              > >Thanks in advance[/color]
              >
              >[/color]

                Comment

                Previous template Next
                Working...