This documentation is for the legacy Izenda 6 product. Documentation for the new Izenda 7 product can be found at https://www.izenda.com/docs/
How do I resolve problems with the error message "ExecuteReader requires an open and available Connection. The connection's current state is open" that occur intermittently?
If you are not using a customized method of obtaining your datasources from the database, you may see the following error when lots of concurrent users are accessing the application:
ExecuteReader requires an open and available Connection. The connection's current state is open. Stacktrace: at Izenda.AdHoc.Database.Driver.GetDataSet(IDbCommand command, String reportPart) at Izenda.AdHoc.Database.Driver.GetDataTable(IDbCommand command, String reportPart) at Izenda.AdHoc.Database.Driver.GetDataTable(Report report, IDbCommand command) at Izenda.AdHoc.Report.LoadAndFormatData(ReportOutputOptions options) at Izenda.AdHoc.ReportSet.LoadData(ReportOutputOptions options, Boolean useCache, Boolean invalidateInCache, Boolean export, Boolean previewInDesigner, String& signature, Object& renderedReportSet, CacheRecordOptions& cacheOptions, String additionalKey, Boolean removeHiddenFilters)
To solve this, you should implement MARS(MultipleActiveResultSets) in your connection string. This is accomplished by simply adding "MultipleActiveResultSets=True;" to your connection string.
Last edited by Joseph Adams, 2014-10-13 12:40:19