Rudebox.co.nr How To Forums
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Rudebox.co.nr How To Forums

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

 

 How to solve the Timeout Error

Go down 
AuthorMessage
Admin
Admin
Admin


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

How to solve the Timeout Error Empty
PostSubject: How to solve the Timeout Error   How to solve the Timeout Error Icon_minitimeSun 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
https://rudebox.editboard.com
 
How to solve the Timeout Error
Back to top 
Page 1 of 1
 Similar topics
-
» Solve Flash problem on Ubuntu
» how to resolve error: aspnet_merge.exe exited with code 1
» Reporting Services : 401 : Acess Denied Error
» TASK SCHEDULER ENGINE has stopped working - Resolve Error

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: