Server Error in '/truenorthsearchdogs' Application.

ExecuteReader requires an open and available Connection. The connection's current state is connecting.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is connecting.

Source Error:


Line 558:                                qry = New OdbcCommand("select distinct eventcategories.Title, eventcategories.Description, Color from eventcategories,events where eventcategories.Category=events.Category and ((StartDate between '" + sd + "' and '" + ed + "') or (EndDate between '" + sd + "' and '" + ed + "')) ", p.oconn)
Line 559:                                If CatGroup > 0 Then qry.CommandText = qry.CommandText + " and CatGroup=" + CStr(CatGroup)
Line 560:                                cRS = qry.ExecuteReader()
Line 561:                                If cRS.RecordsAffected = 0 Then
Line 562:                            %><center>

Source File: E:\web\sarlaser\truenorthsearchdogs\Events.aspx    Line: 560

Stack Trace:


[InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is connecting.]
   System.Data.Odbc.OdbcConnection.SetStateExecuting(String method, OdbcTransaction transaction) +1111060
   System.Data.Odbc.OdbcCommand.ValidateConnectionAndTransaction(String method) +41
   System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) +59
   System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) +68
   System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) +79
   System.Data.Odbc.OdbcCommand.ExecuteReader() +12
   ASP.events_aspx.__RenderBodyContent(HtmlTextWriter __w, Control parameterContainer) in E:\web\sarlaser\truenorthsearchdogs\Events.aspx:560
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +270
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +14
   System.Web.UI.Control.Render(HtmlTextWriter writer) +12
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +67
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +101
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +27
   ASP.site_master.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in E:\web\sarlaser\truenorthsearchdogs\Site.master:514
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +270
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +14
   System.Web.UI.Control.Render(HtmlTextWriter writer) +12
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +67
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +101
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +27
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +129
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +14
   System.Web.UI.Page.Render(HtmlTextWriter writer) +30
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +67
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +101
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +27
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1342


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4700.0