Skip to Content
0
Former Member
Jan 27, 2011 at 04:39 PM

Schedule a report with custom datasource cause "failed to open connection"

27 Views

Dear all,

I have a BOE enterprise Xi 3.1 SP 2.3 running on a RED Hat Enterprise kernel 5.3 with tomcat as web server. I have a report design with crystal report designer. The report default use JDBC as connection to Oracle 11g database. If I select to "Use original database logon information from the report" I can schedule the report and a success instance returned. If I select "Use custom database logon information specified here" and the custom driver inputted "crdb_jdbc". I can not schedule a report and obtain a success instance. It throw "Failed to open connection. {Report Name}"

I have add the Oracle 11g JDBC driver (ojdbc5.jar) to the classpath in bobje/java/CRConfig.xml.

Anything I have missed, Please advice.

Gabriel.