cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Report Windows Forms Viewer: Failed to Open the Connection

former_member349215
Participant

Hi Experts,

One of our clients is running SAP Business One, Version for SAP HANA. I have configured a System DSN (named SAP HANA) in ODBC Data Source Administrator and linked it to the SAP HANA driver installed during installation of hdbclient. On my Crystal Report, I have connected to the HANA DB using the SAP HANA connector created.

I am able to preview the Crystal Report and it retrieves data form the DB very well. I have imported the Crystal Report to SAP Business One. When I try to execute the report in SAP B1, I get the following error (see image below)

I'm not sure why there's no connection yet I have already configured the driver and the Report is working well when I previes on CrystalReport. Kindly Assist

Regards,

Pascale.

Accepted Solutions (1)

Accepted Solutions (1)

former_member349215
Participant

SOLVED

Mt issue was the ODBC Data source connection I had configured. Although it configured well, the naming was the issue. I gave it the name SAP HANA. This was wrong. I should have given it the exact same name as the Server:port and also DSN. For Example 127.0.0.1:30015

Regards,

Pascale.

Answers (0)