 |  |  |  |  |  |  |  |
ASP.NET page stopped responding / cant connect to database
Please support our ASP.NET advertiser: Intel Parallel Studio Home
 |
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! 
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.
•
•
Join Date: Apr 2009
Posts: 220
Reputation: 
Solved Threads: 33
Posting Whiz in Training
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.
Another option is check task manager of your server & then check memory usage, cpu usage. Hope you can find a clue.
MARK AS SOLVED if its help you.
REGARDS
MCTS - Shawpnendu bikash maloroy
http://shawpnendu.blogspot.com
REGARDS
MCTS - Shawpnendu bikash maloroy
http://shawpnendu.blogspot.com
•
•
•
•
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.
Last edited by upstream; Apr 27th, 2009 at 4:57 am.
•
•
Join Date: Apr 2009
Posts: 220
Reputation:
Solved Threads: 33
Posting Whiz in Training
Embeded means did u use anything like this
Where Conn is a connection object.
Conn.BeginTransaction() ???Where Conn is a connection object.
MARK AS SOLVED if its help you.
REGARDS
MCTS - Shawpnendu bikash maloroy
http://shawpnendu.blogspot.com
REGARDS
MCTS - Shawpnendu bikash maloroy
http://shawpnendu.blogspot.com
•
•
Join Date: Apr 2009
Posts: 220
Reputation:
Solved Threads: 33
Posting Whiz in Training
DID YOU USE
BeginTransaction() anywhere in your code? MARK AS SOLVED if its help you.
REGARDS
MCTS - Shawpnendu bikash maloroy
http://shawpnendu.blogspot.com
REGARDS
MCTS - Shawpnendu bikash maloroy
http://shawpnendu.blogspot.com
•
•
Join Date: Apr 2009
Posts: 220
Reputation:
Solved Threads: 33
Posting Whiz in Training
Could you please post codes from connection open to close.
MARK AS SOLVED if its help you.
REGARDS
MCTS - Shawpnendu bikash maloroy
http://shawpnendu.blogspot.com
REGARDS
MCTS - Shawpnendu bikash maloroy
http://shawpnendu.blogspot.com
the previous program only uses con.Open. this is the sample of her code. this a function and simply called if connection is needed
any advice?
•
•
•
•
...
Dim cn As New SqlConnection(connectionString)
If cn.State = Data.ConnectionState.Closed Then
cn.Open()
End If
...
•
•
Join Date: Apr 2009
Posts: 220
Reputation:
Solved Threads: 33
Posting Whiz in Training
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.
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.
MARK AS SOLVED if its help you.
REGARDS
MCTS - Shawpnendu bikash maloroy
http://shawpnendu.blogspot.com
REGARDS
MCTS - Shawpnendu bikash maloroy
http://shawpnendu.blogspot.com
|
Similar Threads
- Cannot find server or DNS Error - please help! (Viruses, Spyware and other Nasties)
Other Threads in the ASP.NET Forum
- Previous Thread: ASP.NET Error?
- Next Thread: Menu Control inside the View Control of the Multiview Control
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest ASP.NET Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
.net 2.0 3.5 activexcontrol advice ajax appliances asp asp.net beginner bottomasp.net box browser businesslogiclayer button c# c#gridviewcolumn cac checkbox child class click compatible confirmationcodegeneration content contenttype control countryselector courier css database datagrid datagridview datalist deadlock deployment development dgv dialog dropdownmenu dynamic edit embeddingactivexcontrol feedback fileuploader fill findcontrol flash flv form forms gridview gudi homeedition hosting iframe iis javascript jquery list menu mono mssql multistepregistration nameisnotdeclared novell objects order problem ratings redirect registration relationaldatabases rotatepage search security select serializesmo.table sessionvariables silverlight smartcard sql ssl tracking treeview typeof validatedate validation vb.net virtualdirectory vista visual-studio visualstudio vs2008 web webarchitecture webdevelopment wizard xml xsl
