Symptom
- Getting the below error message while trying to schedule a report via the CMC .
“Failed to open connection”
- Also,getting “Failed to load Database connection error” when trying to view report from Infoview.
"Error:Failed to load Database connection"
Environment
- Red hat 5
- Informix 10
- BusinessObjects Enterprise 3.1
- Informix Client SDK 3.51
- Crystal Reports 2008 V1
Reproducing the Issue
- Log into Infoview.
- Browse to report.
- Right click View/Schedule.
Cause
There are missing variables under the hashed out sections of the suppliedodbc.ini.
Resolution
Its works using the crystal supplied ODBC connector with the CLIENT_LOCALE & DB_LOCALE variables included ,
[pms]
Driver=/usr/local/crystal/bobje/enterprise120/linux_x86/odbc/lib/CRifcl23.so
Description=DataDirect 5.3 Informix Wire Protocol Driver
Database=pms
LogonID=mirsada
Password=tcodd99
HostName=harkum
PortNumber=1547
ServerName=harkum_net
CancelDetectInterval=0
TrimblankFromIndexName=1
ApplicationUsingThreads=1
DB_LOCALE=en_US.819
CLIENT_LOCALE=en_US.CP1252
Keywords
KBA , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , Problem