Problem of Deployment of crystal report on a x64-development client
We have a issue with running crystal report on our development server (with OS = 64-bit Window Server 2003).
After crystal report files (.rpt) is saved on the BOE server (32-bit), when it is opened through InfoViewApp or OpenDocument, the connection to MySQL failed, the error message "Failed to open the connection"
Both 32-bits and 64-bits MySQL ODBC connectors are installed on the machine and both system and user DSN has been added on the system. After setting the database configuration in the CmcApp, there is no connection problem when opening the rpt file directly with another crystal report development platform, data can be correctly drawn when previewing the report.
Can you help to trouble shoot the issue ?
Any help is highly appreciated.
Tim Ziemba replied
I'm not sure it's related but we've run into other ODBC issues due to the 2 seperate REG keys where ODBC is managed in 64 bit windows.
"Copy your Business Objects ODBC-related registry keys to the Win64 branch of the registry. Open regedit.exe and copy the CMS and Audit DSN keys (manually, by re-creating them -- takes 5-10 minutes) from HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\ to HKEY_LOCAL_MACHINE\Software\Wow6432Node\ODBC\ODBC.INI\ "
If you aren't familiar with editing your windows registry or backing it up please open a message with support as any mistaked could potentially cause worse problems with your OS.
Hope this helps...