I could do with some help as i’m pretty well stuck.
I’m trying to connect crystal report 11.5 ( XI R2 ) developer to DOMSQL on a remote server via jdbc.
I have copied com.ibm.domino.domsql.driver_1.0.0.jar into “C:\Program Files\Common Files\Business Objects\3.0\java\lib\external”
I then opened the CRConfig.xml in “C:\Program Files\Common Files\Business Objects\3.0\java\lib” and added “C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/com.ibm.domino.domsql.driver_1.0.0.jar;” after the last semicolon just before ${CLASSPATH}
I then open Crystal reports, standerd report wizard, create new connection, JDBC (JNDI), I then enter my DB URL: “jdbc:domsql://serv01/cois_v2/cois_crm.nsf/crm” and driver class “com.ibm.domino.domsql.DomSQLDriver”.
Then next, username and password. When I try to connect, I get the error:
Failed to Open Connection
Details: JDBC Driver not found
Any idea? I think I’ve done everything right
UPDATE: The problem is in the JDK that is installed with CR. I have installed an updated version of the Java JDK (c:\jdk) and changed the path for JavaDir in CRConfig.xml. Now I am able to connect to the DomSQL server
UPDATE 2: I have also successfully tested with JRE instead of JDK. here is the exact version, I used
java version “1.6.0_24”
Java(TM) SE Runtime Environment (build 1.6.0_24-b07)
Java HotSpot(TM) 64-Bit Server VM (build 19.1-b02, mixed mode)
Maybe it doesn’t like those forward slashes it the path?
Tried also with backslash; no difference
What version of JRE did you use or did it have to be the JDK?
Thanks
-Toby
Jre should wirk also. Will test when back in the office. I used Java 1.6. 1.5 should be fine as well. It depends on the driver. The domsql driver obviously requires a higher version than 1.4.
I have also successfully tested with JRE instead of JDK. here is the exact version, I used
java version “1.6.0_24”
Java(TM) SE Runtime Environment (build 1.6.0_24-b07)
Java HotSpot(TM) 64-Bit Server VM (build 19.1-b02, mixed mode)
Certainly a fantastic piece of work … It has relevant information. Thanks for posting this. Your blog is so interesting and very informative.Thanks sharing. Definitely a great piece of work Thanks for your work.