• Getting ‘JDBC driver not found error’ while trying to connect DOMSQL from crystal through jdbc

    By Ulrich Krause 1 decade ago

    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

    • Did you manage to solve it?

      By Philippe Riand 1 decade ago

      I don't know crystal report, but it looks like a configuration issue