Skip to Content
0

Issue running Crystal Reports (32 ODBC Driver)

Feb 03, 2017 at 02:09 AM

87

avatar image

Experts,
Need your suggestions in configuring 32 bit ODBC connection in BI 4.2 environment to run Crystal Reports 2016 which were migrated from Crystal Reports 2008.

Environment Details:
BI Version: BI 4.2 SP3
BI Server OS: RHEL 7.2

As the Crystal Reports 2016 uses 32 bit drivers, I have created a file odbc32.ini in the same place where odbc.ini file exists i.e. /<file system>/sap_bobj/enterprise_xi40/ and added the ODBC entry. On refreshing the Crystal Report from CMC, I see below error.

"The viewer could not process an event. Error in File <Report Name>: Failed to load database information. [] ---- Error code:0 [CRWEB00000119]"

Not sure if I missed any configurations. Any suggestions?

bash profile variables for ODBC connectivity:
export ODBC_HOME=/<file system>/sap_bobj/enterprise_xi40/linux_x64/odbc
export ODBC_HOME32=/<file system>/sap_bobj/enterprise_xi40/linux_x86/odbc
export ODBCINI=/<file system>/sap_bobj/enterprise_xi40/odbc.ini
export ODBCINI32=/<file system>/sap_bobj/enterprise_xi40/odbc32.ini

Regards,

Samraj Devunuri

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Brian Dong Feb 03, 2017 at 05:58 PM
0

Hi Samraj,

Instead of trying to create an ODBC32.INI, you should be using the 32 Bit ODBC Administrator to create the ODBC entry.

What database are you trying to connect to?

What odbc driver are you using?

What version of Windows are you running?

I also believe 32 bit ODBC entries need to be in the Windows registry as well. Not just the INI.

Brian

Share
10 |10000 characters needed characters left characters exceeded
Samraj Devunuri Feb 03, 2017 at 08:13 PM
0

Thanks Brian for your response.

OS on which BO running is Linux RHEL. Am trying to connect SQL & ISAM data source. After updating the DNS entry in odbc.ini file, I ran below command, which confirm the connectivity works from the server. However unable to view the reports from CMC/Launchpad as ODBC32 yet to be configured completely which is where I need help.

isql -v mydsn myusername mypassword

Share
10 |10000 characters needed characters left characters exceeded