Wednesday, March 7, 2012

Facing Timeout Error

I am facing Timeout Error as i am using SQL Server 2005 as a database and in database set pooling property as 0 and RemoteTimeout as 0 also as a front end i am using .net 2005 and in web.config file i set pooling=False but then also i am getting the following error.
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 can i do then...?
For some reason the application seems not to grab the information with Connectionpooling = false. See if another conenction string is used instead.
Jens K. Suessmeyer.

-
http://www.sqlserver2005.de
-|||

If you are using SQLClient driver then the connection string attribute is Pooling=False;

However the bigger issue is why are you not closing your connections, you should focus on this and then remove the Pooling=False because disabling pooling will cause a huge performance issue on your SQL Server.

No comments:

Post a Comment