Connection String issue into Crystal report SAP business One

[nikunjmehta2290]

Dear all,

I am facing error while making connection string in crystal report.

Help me on this one.

error-connection.png

SAP Business One HANA

Regards,

Nikunj

[nikunjmehta2290 · Accepted solution]

It's closed. There is issue in connection string which I have solved it.

[shahbaz_akbar]

Hi Nikunj

Try this string

For 32 Bit ODBC

DRIVER=B1CRHPROXY32;SERVERNODE=ServerName:30015;DATABASE=DataBaseName;

For 64 Bit ODBC

DRIVER=B1CRHPROXY;SERVERNODE=ServerName:30015;DATABASE=DataBaseName;

[nikunjmehta2290]

Not working

[shahbaz_akbar]

Please check in the ODBC data source that B1CHRPROXY32 driver is installed or not.?

[Sriram2009]

Hi Nikunj

Check the table, or view exists in DB & DB user has rights to view the table or view?

Regrads

SS

[nikunjmehta2290]

YES, all are checked but not solved the issue

[Sriram2009]

Hi Nikunj

Check this SAP note 1875926

Regards

SS

[nikunjmehta2290]

Thanks for the quick reponse but I don't have S user.