1854744 - Error: CrystalDecisions.CrystalReports.Engine.LogOnException: Database Logon Failed

Symptom

When a report is connecting to Oracle 11g database in a 32 bit Visual Studio .NET application the error is thrown:

CrystalDecisions.CrystalReports.Engine.LogOnException: Database Logon Failed. ---> System.Runtime.InteropServices.COMException: Database logon failed.

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.ReportDocument.ExportToStream(ExportOptions options)
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToHttpResponse(ExportOptions options, HttpResponse response, Boolean asAttachment, String attachmentName)
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToHttpResponse(ExportFormatType formatType, HttpResponse response, Boolean asAttachment, String attachmentName)

Environment

SAP Crystal Reports, developer version for Microsoft Visual Studio
Microsoft Visual Studio
Oracle 11g

Cause

Provider used was Microsoft Driver for Oracle (MSDAORA)

Resolution

Microsoft driver for Oracle only supports Oracle up to version 7
See Limitations of Microsoft Oracle ODBC Driver and OLEDB Provider for more details

Keywords

crvs vs 2012 2010 db prompt log on , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , Problem

Product

SAP Crystal Reports, developer version for Microsoft Visual Studio