JDBC Driver Not Found
I know this topic has been posted multiple times across forums so I apologize. I swear I'm doing everything I thought I had to do but I'm still not having any luck.
I have Crystal Reports 2008 SP3 installed on my machine and we are running an Oracle 11g database. I am running java sdk 1.6.
I am trying to create an oracle JDBC connection in the Crystal Reports Designer.
I set it up with the following information:
Connection URL: jdbc:oracle:thin:@devdb:1521:MNT64
Database Classname: oracle.jdbc.driver.OracleDriver (I've also tried oracle.jdbc.OracleDriver)
I hit next and the service comes up as devdb and then I can enter a username/password.
I get the 'JDBC Driver Not Found' error when I click Finish.
Now, I modified CRConfig.xml's classpath to include this under the JavaServer-Configuration section::
<Classpath>C:\Program Files\Business Objects\Common\4.0\java/lib/external/ojdbc6.jar;$</Classpath>
I also copied ojdbc6.jar from C:\oracle\product\11.1.0\db_1\jdbc\lib to the external folder for Business Objects.
I still get the error.
One thing I have thought of is my machine currently also has Crystal Reports Designer version 9 and 11 installed since I have to support crystal for multiple versions of our product and am still playing with 2008. Maybe this is causing issues?
Dirk-Jan van Gerwen replied
I've had a similar problem connecting to Postgresql through JDBC.
Initially I downloaded their JDBC4 driver and placing it in all ext-folders I could find, I only got the "Driver not found"-message.
Yesterday, I considered using their JDBC3 version (for pre-1.6 Java) and suddenly it worked.
Apparently, CR2008 doesn't use Java 1.6 yet...