943,822 Members | Top Members by Rank

Web Development > ASP.NET > ASP.NET page stopped responding / cant connect to database
Ad:
  • ASP.NET Discussion Thread
  • Marked Solved
  • Views: 1007
  • ASP.NET RSS
You are currently viewing page 1 of this multi-page discussion thread
Permalink
Apr 24th, 2009
0

ASP.NET page stopped responding / cant connect to database

Expand Post »
hi all.

Here's my set-up:
Server 1: SQL Server 2005 Database
Server 2: Public Web Application using ASP.NET VB and IIS6

my newly published website is succesfully running! ~ but after a few minutes (or in some instances)..my application is stopping from responding, it only shows the hourglass cursor, almost forever . i still can't point out the problem, most like, database connectivity (but i was able to login at first, but its failing after a few minutes), but when im deleteting the published files and restoring it from the wwwroot folder. its working again. any similar experience and tips to troubleshoot this? xD badly need help. thanks!
Similar Threads
Reputation Points: 10
Solved Threads: 1
Light Poster
upstream is offline Offline
43 posts
since Sep 2007
Permalink
Apr 24th, 2009
0

Re: ASP.NET page stopped responding / cant connect to database

I cant say that I ran into the same problem but I have run into issues when I forgot to copy over the file called precompiledApp.config to my production server.
Reputation Points: 10
Solved Threads: 1
Newbie Poster
mcdt2424 is offline Offline
9 posts
since Sep 2007
Permalink
Apr 25th, 2009
0

Re: ASP.NET page stopped responding / cant connect to database

Most of the times i found that sql server not responding. This happened for my case is if i cretae a connection with transaction & try to run a select statement without embedding transaction then sql server behave like this.

Another option is check task manager of your server & then check memory usage, cpu usage. Hope you can find a clue.
Reputation Points: 26
Solved Threads: 44
Posting Whiz in Training
mail2saion is offline Offline
247 posts
since Apr 2009
Permalink
Apr 27th, 2009
0

Re: ASP.NET page stopped responding / cant connect to database

Click to Expand / Collapse  Quote originally posted by mail2saion ...
Most of the times i found that sql server not responding. This happened for my case is if i cretae a connection with transaction & try to run a select statement without embedding transaction then sql server behave like this.

Another option is check task manager of your server & then check memory usage, cpu usage. Hope you can find a clue.
Im sorry, but. what's an embedded transaction??? i think that's my problem..
Last edited by upstream; Apr 27th, 2009 at 4:57 am.
Reputation Points: 10
Solved Threads: 1
Light Poster
upstream is offline Offline
43 posts
since Sep 2007
Permalink
Apr 27th, 2009
0

Re: ASP.NET page stopped responding / cant connect to database

Embeded means did u use anything like this Conn.BeginTransaction() ???
Where Conn is a connection object.
Reputation Points: 26
Solved Threads: 44
Posting Whiz in Training
mail2saion is offline Offline
247 posts
since Apr 2009
Permalink
Apr 27th, 2009
0

Re: ASP.NET page stopped responding / cant connect to database

DID YOU USE BeginTransaction() anywhere in your code?
Reputation Points: 26
Solved Threads: 44
Posting Whiz in Training
mail2saion is offline Offline
247 posts
since Apr 2009
Permalink
Apr 27th, 2009
0

Re: ASP.NET page stopped responding / cant connect to database

oh, the code doesn't have that. will check on this issue.
Reputation Points: 10
Solved Threads: 1
Light Poster
upstream is offline Offline
43 posts
since Sep 2007
Permalink
Apr 27th, 2009
0

Re: ASP.NET page stopped responding / cant connect to database

Could you please post codes from connection open to close.
Reputation Points: 26
Solved Threads: 44
Posting Whiz in Training
mail2saion is offline Offline
247 posts
since Apr 2009
Permalink
Apr 27th, 2009
0

Re: ASP.NET page stopped responding / cant connect to database

the previous program only uses con.Open. this is the sample of her code. this a function and simply called if connection is needed

Quote ...
...
Dim cn As New SqlConnection(connectionString)

If cn.State = Data.ConnectionState.Closed Then
cn.Open()
End If
...
any advice?
Reputation Points: 10
Solved Threads: 1
Light Poster
upstream is offline Offline
43 posts
since Sep 2007
Permalink
Apr 27th, 2009
0

Re: ASP.NET page stopped responding / cant connect to database

Did u use any third party component for accessing database or executing query LIKE .nettiers

Another observation is did you check the server cpu usage & memory usage exactly when this error occured.

Did this error is execution timeout or anything else. if so then post error description also.
Reputation Points: 26
Solved Threads: 44
Posting Whiz in Training
mail2saion is offline Offline
247 posts
since Apr 2009

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in ASP.NET Forum Timeline: ASP.NET Error?
Next Thread in ASP.NET Forum Timeline: Menu Control inside the View Control of the Multiview Control





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC