SAP Knowledge Base Article - Public

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

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

  1. Log into Infoview.
  2. Browse to report.
  3. 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

Product

Crystal Reports Server 2008 V1