Crystal Reports viewer reports, 'Failed to open the connection.' Read this document to find out how to address your connection issues! You try to open or refresh data on a report, and get a message box that says 'failed to open the connection.' Windows SysWOW64 odbcad32.exe; If using ODBC.
We use an ERP/CRM system called Vantage (by Epicor) and this uses Crystal Reports for all kinds of things.
When users with Windows 7 Professional tried to view a report generated using Crystal, the report would display inside a Vantage window for less than a second, then crash. This behaviour didn't happen on Windows Vista, it only started on Windows 7.
The solution to this for us was to install and run 'Crystal Reports XI R2 .net 1.1 runtime' which we got from the Epicor website.
PM me if you'd like a link to this to try.