I am developing a web application that has to show a report with CrystalRepor v. 13.0.2000.0 (devoloper version for visual studio 2015). This report in development environment with Windows 7 64bits works perfectly and generates the PDF from the report. When I publish the application on the Windows 2012 server with IIS 8.5.9600.16384 in which I have already installed the CrystalReport module same version as development environment at the time of executing the report and generating the PDF I reported the following error.
CrystalDecisions.CrystalReports.Engine.InternalException: Could not be open the connection. The connection could not be opened. Application Form 13220_6192_ {BF2A6F00-4608-4D36-8EDB-8E09BBFE960A} .rpt --- > System.Runtime.InteropServices.COMException: Could not open the Connection. The connection could not be opened. Application Form 13220_6192_ {BF2A6F00-4608-4D36-8EDB-8E09BBFE960A} .rpt in CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export (ExportOptions pExportOptions, RequestContext pRequestContext) in CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream (ExportRequestContext reqContext) --- End of stack trace of internal exception --- in CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException (Exception e) in CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream (ExportRequestContext reqContext) in CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream (ExportRequestContext reqContext) in CrystalDecisions.CrystalReports.Engine.FormatEngine.Export (ExportRequestContext reqContext) in CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToDisk (ExportFormatType formatType, String fileName) in Aplicacions.ceo.AccesDades.CrearPDF (String usuari, Int32 idActivitat)
On the server I created an ODBC 32b connection to the bbdd PostgreSql because I do not know how to make a connection from CrystalReport to the DB by means of a connectionstring (if someone tells me I will be very grateful). No more waiting for some good Samaritan to enlighten me in this mistake that I have been with for a few days. Ah! very important if I publish the application on a machine with windows7 + iis works perfectly. But I need to publish it on server windows 2102. Thank you for your attention. Xavier Crespo