Crystal Reports 11 connecting to Oracle Database using JDBC driver
Hello,
I have Crystal Reports 11 installed on my workstation. I am trying to connect to Oracle 11g database using JDBC driver. The java version we use is 1.6. The problem is I am getting an error "Failed to open connection. JDBC Driver Not found. But I followed the instructions as below. It worked for me one time on my workstation but then when I tried the same thing on a different workstation with my account on a same domain, it did not work. Then I tried on my workstation but I got the error message. I had to reinstall crystal reports and works again. I am not sure if it has to do with profile from one workstation to the other. But I need to set this up in 6 different workstations and I am not able to succeed.
Please assist. Thank you very much.
Here is what I did.
1. I installed Crystal Reports 11.
3. Copied the Ojdbc6_g.jar file from Oracle 11 g client location and placed in the location C:\Program Files (x86)\Common Files\Business Objects\3.0\java\lib\exter
4. Modified CRConfig.XML with this classpath in location C:\Program Files (x86)\Common Files\Business Objects\3.0\java
5. Open Crystal Reports 11, click on new report, create a new connection and selected JDBC (JNDI).
6. Connection url: jdbc:oracle:thin:@111.111.
7. Classname: Oracle.jdbc.driver.OracleD
8. Click next and it prompts for user credentials. Once the user information is given then the next screen is shown as below.
I have Crystal Reports 11 installed on my workstation. I am trying to connect to Oracle 11g database using JDBC driver. The java version we use is 1.6. The problem is I am getting an error "Failed to open connection. JDBC Driver Not found. But I followed the instructions as below. It worked for me one time on my workstation but then when I tried the same thing on a different workstation with my account on a same domain, it did not work. Then I tried on my workstation but I got the error message. I had to reinstall crystal reports and works again. I am not sure if it has to do with profile from one workstation to the other. But I need to set this up in 6 different workstations and I am not able to succeed.
Please assist. Thank you very much.
Here is what I did.
1. I installed Crystal Reports 11.
3. Copied the Ojdbc6_g.jar file from Oracle 11 g client location and placed in the location C:\Program Files (x86)\Common Files\Business Objects\3.0\java\lib\exter
4. Modified CRConfig.XML with this classpath in location C:\Program Files (x86)\Common Files\Business Objects\3.0\java
5. Open Crystal Reports 11, click on new report, create a new connection and selected JDBC (JNDI).
6. Connection url: jdbc:oracle:thin:@111.111.
7. Classname: Oracle.jdbc.driver.OracleD
8. Click next and it prompts for user credentials. Once the user information is given then the next screen is shown as below.
ASKER
No, I have not. How can I do that?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
mlmcc