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?