SAP Crystal Reports Server (not IFS's own Crystal Web Service) fails to connect to the Oracle database when running reports against IFS data, even though the connection details look correct — what's worth checking regarding the Oracle client driver bitness?

All FAQ questions / Reporting and analytics

Answer

Check that the Oracle client driver bitness actually matches what that specific Crystal version requires — Crystal Reports 2016 works with 32-bit Oracle client drivers, while Crystal 2020 (and Crystal Reports Server) specifically require 64-bit drivers instead. Uninstalling mismatched 32-bit drivers and installing the correct 64-bit ones resolves a 'not connecting to the database' symptom in this scenario, after which scheduling and emailing reports against IFS data works correctly.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Reporting and analytics questions