Skip to Content
avatar image
Former Member

Issue running Crystal Reports (32 ODBC Driver)

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


Samraj Devunuri

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 03, 2017 at 05:58 PM

    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.


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 03, 2017 at 08:13 PM

    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

    Add comment
    10|10000 characters needed characters exceeded