Crystal Reports MySql jdbc connection

Message

   Hello all, 

I could do with some help as i'm pretty well stuck.

I'm trying to connect crystal report developer to a MySql Database on a remote server via the j-connector for jdbc.

I have downloaded the connecter J zip file, extracted the folder and copied the mysql-connector-java-5.1.13-bin.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/mysql-connector-java-5.1.13-bin.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:mysql://ipaddressformysqlserver:3306/database1" and driver class "com.mysql.jdbc.Driver".

Then next, username and password. Then on connect I get the error: 

Failed to Open Connection
Details: JDBC Driver not found

Any idea? I think ive done everything right. 

Im running Java SE 1.4, does it need to be the JDK?

Thanks for the help,

Matt

Edited by Ballboy1 - 26 Aug 2010 at 2:49am