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