User701807890 posted
I am having a problem with Database connection error when more then one request sending on same page / target in same time, one request returning with correct response but other user getting error. the error I am getting find below.
Exception of type 'System.Web.HttpUnhandledException' was thrown.System.InvalidOperationException: Execution of the command requires an open and available connection. The connection's current state is closed. at System.Data.Objects.ObjectContext.EnsureConnection() at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable.GetEnumerator() at LawAccessPublicWebsiteTest.Businesslogic.Utility.GetParentCategoryID(Int32 ChildCat) at LawAccessPublicWebsiteTest.Businesslogic.Utility.GetNiceUrl(CatType CatTypeFor, Int32 CatID) at LawAccessPublicWebsiteTest.UserControls.CtrlSecTerCatSearch.showTitle() at LawAccessPublicWebsiteTest.UserControls.CtrlSecTerCatSearch.set_parentCatID(Int32 value) at LawAccessPublicWebsiteTest.UserControls.CtrlCateogry.set_CategoryID(Int32 value) at LawAccessPublicWebsiteTest.SearchV1.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Server : IIS7 and IIS6, ASP.NET 4.0 Entity frame work 4.0 , C#
Please let me know any other information regarding this issue. Any advise would be more appreciated and thanks in advanced.
Cheers
