[SOLVED] Crystal Reports JDBC not connecting

Crystal Reports JDBC not connecting

I am running crystal reports 2008, and oracle11g. I have tested the connection in SQL developer and i can connect just fine.
However if i try and create a new JDBC connection in Crystal Reports i get ther error

Failed to Open the connection.

Details: JDBC driver not found.

I have the following set up:

Oracle Home: C:\Oracle\product\11.1.0\client_2\jdbc\lib\ojdbc6.jar
path: C:\Oracle\product\11.1.0\client_2\bin; + hell of a lot more
I've added C:\Program Files (x86)\Business Objects\Common\4.0\java/lib/external/ojdbc6.jar;$ to the classpath in the CRConfig.xml file.

Why can i not create a connection?

Solution

The issue was that I have a windows 7 64 bit machine, with the 64 Bit crystal and 64 bit Oracle. The 64bit oracle does not interact very well with crystal. The issues were resolved once i installed the 32 bit version of Oracle.