0

Hi all

I am using asp.net 4.0 for my application that connects to sql server 2008 via ADO.Net Entity Framework. When there is bit increase in traffic the site goes down. I notice below error in event management

Execution of the command requires an open and available connection. The connection's current state is broken.

I am developing application with Entity Framework for the first time, and its opening and closing connection by itself. What i think is the connection to data base needs to be opened and closed manually.

If i am rite kindly tell me how can i do it but if i am not what other thing might throw this exception.

Regards

3
Contributors
6
Replies
9
Views
6 Years
Discussion Span
Last Post by fawadkhalil
0

How many active connections have you got specified. I would think increasing the size of the connection pool would help.
Also, checking that the open connections are used as efficiently as possible; you want them returned to the pool the instant they are free.

0

I guess you are pointing at max pool size in connection string, i don't have that specified.

0

The server will have a default connection size. Depending on how you are hosting the site there are various ways to alter it. If you have access to a cpanel for your host you would probably be able to find it there. If you are hosting it yourself it will be in a config somewhere.

0

Yes i have access to the control panel but i have not change the settings because i have no knowledge of it and i fear some thing might go wrong. Can you guide me where can i find it and what settings should i change?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.