Rudebox.co.nr How To Forums

Rudebox How To Forums - Ask Anything, View How To's
 
HomeFAQSearchRegisterMemberlistUsergroupsLog in

Share | 
 

 How to solve the Timeout Error

Go down 
AuthorMessage
Admin
Admin
avatar

Number of posts : 216
Registration date : 2007-01-01

PostSubject: How to solve the Timeout Error   Sun Oct 28, 2007 6:09 pm

Error

System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.

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.


What to do :
a) In connection String put
Code:
 ;Connect Timeout=0

b)Make sure all your connections are force closed

The place where you are getting this error or everywhere where you are assigning a connection string, do below: example

Code:

SqlConnection connection = getConnection()

try
{
connection.Open;
Do whatever you want to with it...
}
finally
{
connection.Close();
}

getConnection - returns an SqlConnection object (You have to write this by your own)

c)If problem is still there

In connection string also add

Code:
;Max Pool Size=10000
Back to top Go down
View user profile http://rudebox.editboard.com
 
How to solve the Timeout Error
Back to top 
Page 1 of 1
 Similar topics
-
» 2147287038 error, please help
» -2147287038 (Unspecified Error 0x80030002) I d/c after a few minutes of playing!
» Error message when gifting
» Impossible chess puzzle to solve for chess engines?
» Photobucket Problems

Permissions in this forum:You cannot reply to topics in this forum
Rudebox.co.nr How To Forums :: How To - Myspace / Website /Blog Utilities :: ASP .net-
Jump to: