Skip to Content

Crystal report old db connection

I find to connect sap crystal report to hana DB for doing some report. I would use the OLE DB connection.

On sql server the report run and crystal report was connected to the database but when i try to connect crystal reports to hana DB the connection don't run.

I have this problem: the databese list on the connection wizard was empty.

I have select the SAP HANA MDX PROVIDER. Is the correct provider or there are othere solution for solve this problem?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 04, 2018 at 04:47 PM

    Which version of Crystal are you using? Have you installed a version of the HANA client that is the exact same version as the HANA server you're connecting to?

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

    • Hi, i use sap crystal report 16.

      I have necessity to use ODBC provider for x64 machine but the connection on sap crystal report connection wizard don't work, do you have some solution?

  • Dec 04, 2018 at 11:24 PM

    Hi,

    Prerequisites •

    You have installed the SAP Business One, version for SAP HANA client on the computer on which you want to design Crystal Reports layouts. For more information, see the SAP Business One Administrator's Guide, version for SAP HANA.

    Note

    You must meet this prerequisite if you want to use B1CRHPROXY32 as the connection driver.

    • You have installed the SAP HANA database client software on the computers on which you want to design Crystal Reports layouts. For more information, see SAP HANA Database – Client Installation Guide on the SAP Help Portal at http://help.sap.com/hana_appliance.

    • You have installed the SAP Crystal Reports, version for the SAP Business One application. For more information, see the SAP Business One Administrator's Guide, version for SAP HANA.

    Creating a New ODBC(RDO) Connection Driver To create a new connection driver:

    1. On the SAP Crystal Reports Start Page, choose Blank report. A tab for the new report with the Database Expert window appears. Note If you prefer, you can work with the standard report creation wizard. Instead of Blank report, choose Standard Report. For more information about the standard report creation wizard, see the SAP Crystal Reports online help.

    2. In the Database Expert window, in the Available Data Sources pane on the left- hand side of the screen, choose Create New Connection → ODBC(RDO) → Make New Connection. The ODBC(RDO) Data Source Selection window appears.

    3. Select the Enter Connection String radio button, and in the Connection String field, enter either of the following strings (as required):

    - To use B1CRHPROXY32 as the connection driver,

    enter DRIVER={B1CRHPROXY32};UID=<SAP HANA Database User Name>;PWD=<SAP HANA Database User Password>;SERVERNODE=<SAP HANA Database Server Address>:<SAP HANA Database Instance Port>;DATABASE=<Company Schema> Note The company schema name on the SAP HANA instance is optional. If you specified the company schema in the connection string, only this schema appears as an available data source. If you did not specify the company schema in the connection string, all the schemas on the specified SAP HANA instance appear as available data sources.

    -To use HDBODBC32 as the connection driver, enter DRIVER={HDBODBC32};UID=<SAP HANA Database User Name>;PWD=<SAP HANA Database User Password >;SERVERNODE=<SAP HANA Database Server Address>:<SAP HANA Database Instance Port> Note If you use HDBODBC32 as the connection driver, you can only access tables and views through queries. For more information, see Selecting and Creating Data Sources.

    4. In the ODBC(RDO) Data Source Selection window, choose the Finish button. The connection driver appears under ODBD(RDO) in the Database Expert window.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi, i use sap crystal report 16.

      I have necessity to use ODBC provider for x64 machine but the connection on sap crystal report connection wizard don't work, do you have some solution?

  • Dec 12, 2018 at 02:32 PM

    Hi, i use sap crystal report 16.

    I have necessity to use ODBC provider for x64 machine but the connection on sap crystal report connection wizard don't work, do you have some solution?

    Add comment
    10|10000 characters needed characters exceeded