Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. Sql Time out Error

Sql Time out Error

Scheduled Pinned Locked Moved ASP.NET
databasehelpquestion
10 Posts 5 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • K Offline
    K Offline
    ksss_maheshece
    wrote on last edited by
    #1

    Hi friends, I'm facing SqlTime out error in My web Application.Even though i increase my connection time out,it still showing error. I've restarted my Sql services but it's working for 1 hr then time out Repeated. I checked each connection I've used.it was closed properly. What may be the error? Thanks&Regards, Mahez Confused

    A S L 3 Replies Last reply
    0
    • K ksss_maheshece

      Hi friends, I'm facing SqlTime out error in My web Application.Even though i increase my connection time out,it still showing error. I've restarted my Sql services but it's working for 1 hr then time out Repeated. I checked each connection I've used.it was closed properly. What may be the error? Thanks&Regards, Mahez Confused

      A Offline
      A Offline
      Abhijit Jana
      wrote on last edited by
      #2

      Did you tried by debug your code ? Set breakpoint and try to debug. check there is any black spot in your code or not.

      Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Visit My Latest Article : Beginner's Guide : Exploring IIS 6.0 With ASP.NET

      N K 2 Replies Last reply
      0
      • K ksss_maheshece

        Hi friends, I'm facing SqlTime out error in My web Application.Even though i increase my connection time out,it still showing error. I've restarted my Sql services but it's working for 1 hr then time out Repeated. I checked each connection I've used.it was closed properly. What may be the error? Thanks&Regards, Mahez Confused

        S Offline
        S Offline
        sashidhar
        wrote on last edited by
        #3

        ksss_maheshece wrote:

        .Even though i increase my connection time out

        First things first Check You Connection string..! SomeTime Connection String MAy be the problem..! Clear Your Application pool..!Or If it is local Restart Your IIS..!

        MyFirstArticlePublished: MenuControlSelectedItem Why Do Some People Forget To Mark as Answer .If It Helps.

        1 Reply Last reply
        0
        • A Abhijit Jana

          Did you tried by debug your code ? Set breakpoint and try to debug. check there is any black spot in your code or not.

          Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Visit My Latest Article : Beginner's Guide : Exploring IIS 6.0 With ASP.NET

          N Offline
          N Offline
          nagendrathecoder
          wrote on last edited by
          #4

          I bet he is not going to do that. This is a repost. I already suggested this to him but he didn't replied back. ;)

          A 1 Reply Last reply
          0
          • K ksss_maheshece

            Hi friends, I'm facing SqlTime out error in My web Application.Even though i increase my connection time out,it still showing error. I've restarted my Sql services but it's working for 1 hr then time out Repeated. I checked each connection I've used.it was closed properly. What may be the error? Thanks&Regards, Mahez Confused

            L Offline
            L Offline
            Lost User
            wrote on last edited by
            #5

            make pooling="false" it will solve the prb.

            Thanks and Regards Sujit Kr. Mandal

            S K 2 Replies Last reply
            0
            • A Abhijit Jana

              Did you tried by debug your code ? Set breakpoint and try to debug. check there is any black spot in your code or not.

              Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Visit My Latest Article : Beginner's Guide : Exploring IIS 6.0 With ASP.NET

              K Offline
              K Offline
              ksss_maheshece
              wrote on last edited by
              #6

              I've tried to debug my code(Sql prcocedure).it replies the same even after the Timeout error.

              1 Reply Last reply
              0
              • N nagendrathecoder

                I bet he is not going to do that. This is a repost. I already suggested this to him but he didn't replied back. ;)

                A Offline
                A Offline
                Abhijit Jana
                wrote on last edited by
                #7

                nagendrathecoder wrote:

                This is a repost. I already suggested this to him but he didn't replied back.

                Ohh..Sorry ! I didn't noticed that. Yes, rather than starting a new thread for same question it always helpful if he replied on the earlier post. But I don't know why..... :(

                Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Visit My Latest Article : Beginner's Guide : Exploring IIS 6.0 With ASP.NET

                K 1 Reply Last reply
                0
                • L Lost User

                  make pooling="false" it will solve the prb.

                  Thanks and Regards Sujit Kr. Mandal

                  S Offline
                  S Offline
                  sashidhar
                  wrote on last edited by
                  #8

                  Sujit Mandal wrote:

                  make pooling="false"

                  IMO May Be Thts a Bad Idea..!:cool:

                  MyFirstArticlePublished: MenuControlSelectedItem Why Do Some People Forget To Mark as Answer .If It Helps.

                  1 Reply Last reply
                  0
                  • L Lost User

                    make pooling="false" it will solve the prb.

                    Thanks and Regards Sujit Kr. Mandal

                    K Offline
                    K Offline
                    ksss_maheshece
                    wrote on last edited by
                    #9

                    No, It's not working

                    1 Reply Last reply
                    0
                    • A Abhijit Jana

                      nagendrathecoder wrote:

                      This is a repost. I already suggested this to him but he didn't replied back.

                      Ohh..Sorry ! I didn't noticed that. Yes, rather than starting a new thread for same question it always helpful if he replied on the earlier post. But I don't know why..... :(

                      Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Visit My Latest Article : Beginner's Guide : Exploring IIS 6.0 With ASP.NET

                      K Offline
                      K Offline
                      ksss_maheshece
                      wrote on last edited by
                      #10

                      I've replied that Q but it's went back,therefore ive created a new thread. Here I need to run a job. This job has procedure to execute.This taking too much of time. Now only it's happening but not before. Thanks Mahesh

                      1 Reply Last reply
                      0
                      Reply
                      • Reply as topic
                      Log in to reply
                      • Oldest to Newest
                      • Newest to Oldest
                      • Most Votes


                      • Login

                      • Don't have an account? Register

                      • Login or register to search.
                      • First post
                        Last post
                      0
                      • Categories
                      • Recent
                      • Tags
                      • Popular
                      • World
                      • Users
                      • Groups