Issue running Crystal Reports (32 ODBC Driver)

[Former Member]

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

[Former Member]

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

[former_member292966]

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