1493651 - Error:Failed to load Database connection while using Informix 10

• 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"

• Red hat 5  
• Informix 10                                                                                                                         
• BusinessObjects Enterprise 3.1
• Informix Client SDK 3.51                                                                                                            
• Crystal Reports 2008 V1  

1. Log into Infoview.
2. Browse to report.
3. Right click View/Schedule.

There are missing variables under the hashed out sections of the suppliedodbc.ini.

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                                                                                                          
                                                  

KBA , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , Problem