Compatibility with Cache and SAP Crystal Server 2020?

Question

Question

Thomas Hensman · Nov 19, 2021

Is there any information regarding using Cache ODBC DSN's to connect to SAP Crystal Server 2020? We have added all the necessary DSN on the server, and yet when running reports to access the required ODBC connections, we cannot seem to get the connections to establish.

Product version: Caché 2017.1

Discussion (2)0

Log in or sign up to continue

Saurav Acharjee · Dec 15, 2021

What is the error you receive when you try to access the DB from the ODBC? You will see the details error in SMP - System > Security Management > Users > User Profile

0 0

score 1 · Answer 1 · 2021-12-15T19:04:19-05:00

Thanks for the reply. We actually just figured it out. It appears Crystal Server 2020 only supports 64bit ODBC Drivers. Our vendor that manages our Cache Database only provided us with a 32bit driver. We where able to obtain the 64bit driver and it does appear to be working now.