On our website we display the report as a PDF and get the following error using the code below. We have verified the user name, password, server, etc. but it still gives us this error. We have the Crystal Reports 2016 runtime installed on the IIS server to do this. The report uses OLE DB (ADO) to connect to the database. This was working for about 10 years (including when we used XI) and then stopped all of a sudden. Reinstalling the runtime didn't fix the problem. We put debugging code on the export line to show us the parameters and everything is correct.
Exception Type: System.Runtime.InteropServices.COMException
ErrorCode: -2147217393
Message: Database logon failed.
Data: System.Collections.ListDictionaryInternal
TargetSite: System.Object Export(CrystalDecisions.ReportAppServer.ReportDefModel.ExportOptions, CrystalDecisions.ReportAppServer.ReportDefModel.RequestContext)
HelpLink: NULL
Source: Analysis Server
HResult: -2147217393
StackTrace Information
at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.