Posted 3 August 2017, 3:20 pm ESTError: An unexpected error occurred. Additional information: ' CLI0106E Connection is closed. SQLSTATE=08003'
I am newbie,
We are trying to run the DDR reports using the multithreaded application (.Net 3.5 framework). DDR report rendering engine is accessing the DB2 data base in order to generate the results. Each thread opens the connection, fetches the results and closes connection. We are running maximum 4 threads
var _renderingExtension = new DataDynamics.Reports.Rendering.Xml.XmlRenderingExtension();
//using memory instead of file
var _streamProvider = new DataDynamics.Reports.Rendering.IO.MemoryStreamProvider();
Throwing the error when running render method
Report Definition has the Connection properties
string rdlxName = Constants.rdlxAndXslFilePath + gr.StructureFileName;
definition = new ReportDefinition(new FileInfo(rdlxName));
definition.Report.DataSources.DataSourceReference = null;
definition.Report.DataSources.ConnectionProperties.ConnectString = Constants.connectionString;
definition.Report.DataSources.ConnectionProperties.IntegratedSecurity = true;
definition.Report.DataSources.ConnectionProperties.DataProvider = "OLEDB";
Any ideas or suggestions?