I am trying to connect to MySQL database version 5.1 hosted on a web server using IBM Data Studio 4.1. I am getting below error.
The JDBC driver class was not found in the specified JAR or .zip file. Click the ellipsis (...) button to update the path to the JDBC driver files.
Current file and path location: mysql-connector-java-5.1.0-bin.jar
I downloaded the connector file from "http://dev.mysql.com/downloads/connector/j/" but IBM Data Studio doesn't recognize this .zip file as the right .jar file.
Can you please let me know if there is something I am missing that needs to be done for successful connection