Server Error in '/' 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 17:         Dim da As New OdbcDataAdapter(String.Format("SELECT * FROM {0} WHERE YEAR(datum) = {1} ORDER BY datum", "boekingen", lit.Text), DB.AccessConn)
Line 18:         Dim dt As New DataTable
Line 19:         da.Fill(dt)
Line 20:         rep.DataSource = dt
Line 21:         rep.DataBind()

Source File: D:\Sites\vhosts\facetofaceband.nl\httpdocs\controls\Agendalist.ascx.vb    Line: 19

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) +1437646
   System.Data.Odbc.OdbcCommand.ValidateConnectionAndTransaction(String method) +53
   System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) +94
   System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) +145
   System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) +92
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +201
   System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +453
   System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +141
   controls_Agendalist.Repeater1_ItemDataBound(Object sender, RepeaterItemEventArgs e) in D:\Sites\vhosts\facetofaceband.nl\httpdocs\controls\Agendalist.ascx.vb:19
   System.Web.UI.WebControls.Repeater.OnItemDataBound(RepeaterItemEventArgs e) +137
   System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) +191
   System.Web.UI.WebControls.Repeater.AddDataItemsIntoItemsArray(IEnumerable dataSource, Boolean useDataSource) +279
   System.Web.UI.WebControls.Repeater.PostGetDataAction(IEnumerable dataSource) +104
   System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +80
   controls_Agendalist.Page_Load(Object sender, EventArgs e) in D:\Sites\vhosts\facetofaceband.nl\httpdocs\controls\Agendalist.ascx.vb:10
   System.Web.UI.Control.OnLoad(EventArgs e) +106
   System.Web.UI.Control.LoadRecursive() +68
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3785


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