SAP Knowledge Base Article - Public

1819935 - Error: Failed to Open Connection <Crystal Report File name.rpt>"

Symptom

  • Using a report in Visual Studio web application
  • Application works as expected in Visual Studio 2010 IDE
  • Running the application in IIS results in the error:

Failed to Open Connection, Failed to Open Connection <Crystal Report File name.rpt>"

Environment

  • SAP Crystal Reports, Version for Visual Studio .NET
  • Microsoft Visual Studio 2010
  • MYSQL SERVER Database, v. 5.5
  • MySQL ODBC Driver Version 5.2.a

Cause

  • The ODBC datasource was not configured correctly

Resolution

  • Create System DSN
  • For 32 bit connections ensure the DSN is 32 bit - use the ODBC Administrator in "C:\Windows\SysWOW64\odbcad32.exe"

See Also

Keywords

CR2010 2010 CR4VS2010 CR4VS VS2010 NET2010 Crystal Reports for .NET Framework 4.0 crforvs 13 2012 logon log on prompt , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , Problem

Product

SAP Crystal Reports, developer version for Microsoft Visual Studio