New Windows 2022 Server
New install of VC 9.9.12
New install of Crystal Reports 2020 designer
Situation
Trivial test report, simple one table one field output to pdf.
Inside Crystal reports all reports do as they should.
Connection is ODBC.
In VC:
Crystal reports that only output something without accessing db run fine.
Crystal reports that access our older MS SQL server 2014 run fine.
Crystal report that access our current SQL Server 2019 fail with connection:
11.11.2022 13:59:49 Info Task started(Crystal reports): TEST RPT CHDB011 (81)
11.11.2022 13:59:53 Err CreateReport->Crystal reports exception: CrystalDecisions.CrystalReports.Engine.InternalException: Fehler beim Öffnen der Verbindung.
IKOT_TEST_2020 828_6536_{70E46E75-AA69-47A8-8FB2-112A655A6967}.rpt ---> System.Runtime.InteropServices.COMException: Fehler beim Öffnen der Verbindung.
IKOT_TEST_2020 828_6536_{70E46E75-AA69-47A8-8FB2-112A655A6967}.rpt
at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
--- End of inner exception stack trace ---
at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToDisk(ExportFormatType formatType, String fileName)
at ExporterService.RestartDecorator(Object , ExportFormatType , String , ExporterService )
at VisualCronService.ProcessTaskCrystalReportsClass.ReadListener() in C:\git\code\VisualCronService\Jobs\TaskProcesses\Reporting\clsProcessTaskCrystalReports.vb:line 128
11.11.2022 13:59:53 Err CreateReport->Crystal reports inner exception: System.Runtime.InteropServices.COMException (0x800002F4): Fehler beim Öffnen der Verbindung.
IKOT_TEST_2020 828_6536_{70E46E75-AA69-47A8-8FB2-112A655A6967}.rpt
at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
11.11.2022 13:59:54 Info Task completed (Crystal reports) (Failure)->'TEST RPT CHDB011' (81)
11.11.2022 13:59:54 Err Job completed (Failure)->'REPORTING'
The only thing I found on the net is this page from microsoft:
https://learn.microsoft....ed?tabs=ole-db-driver-19 which suggests to add ";Trust Server Certificate=true" to the connection string.
But the VC settings for crystal reports only allow me a server/user/pw and not a connection string.
Is anyone using the crstal feature and hast successfully connected to MS SQL2019?
Thanks
Guido