Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Does JRC support native Oracle db driver or it must use JDBC?

When using JRC and Report Viewer in a thick client to view a Crystal Report (XI R2 or 2008) which accesses the data in an Oracle table, is JDBC required or the native Oracle drive will still work? If the native Oracel driver will work, anything needs to be defined? If JDBC is required, what needs to be setup?Besides of ojdbc14.jar for Oracle 10 (ojdbc5.jar for Oracle 11) in the CLASSPATH, what should be defined in CRConfig.xml? e.g.

<JDBCURL>jdbc:oralce:thin:@dbhost1:1521:ad1</JDBCURL>

<JDBCClassName>oracle.jdbc.OracleDriver</JDBCClassName>

Any sugguestion will be appreciated.

Thanks

replied

Is this a typo:

jdbc:oralce:thin:@dbhost1:1521:db1

The ClassName matches mine.

If the above was a typo, and not resolved, I'd recommend running [Process Monitor|http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx] to see if the Java Server process (java.exe) is picking up the ojdbc5.jar file.

Sincerely,

Ted Ueda

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question