Connect to HANA 2.0 via an ODBC connection in Crystal Reports 2016 SP07

[paul_theconsultant]

Hi All,

I have successfully migrated a SAP Business One 9.3 PL05 database from MsSQL to SAP Business One 10 PL01 on HANA Enterprise 2.0. I am attempting to connect Crystal Reports to HANA database to manually converted some reports. I have read and applied the following support note:

https://apps.support.sap.com/sap/support/knowledge/public/en/2811890

I successfully managed to make a connection via ODBC (RDO) in Crystal Reports - Database Expert. However, after expanding the connection, no migrated SAP Business One databases are being displayed. See attached screenshots.database-expert.png

[paul_theconsultant · Accepted solution]

Hi Members,

We resolved this issue by:

1. Installing both a 32-bit and 64-bit version of SAP HANA client (after extracting it using SAPCAR utility) on the HANA Server.

2. And, In Crystal Reports > Database expert > Create New Connection > ODBD (RDO) > Enter Connection String - we replaced our database server (SAP Business One v10 PL01) port from: 30013 to the default: 30015

[former_member374449 · Accepted solution]

Hello Paul,

Your solution worked for me.

Thank you 😊

With Regards.

Manish