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