This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
Your connection url could be wrong. When you use the DriverManager to get a connection all it does is traverses avaliable drivers to find one which suits the connection url you have supplied. If there isn't one then it won't try to make a connection.
One question though - why use an ODBC driver when there are JDBC drivers available for MySQL?
well the ODBC Driver comes by default with the JDK and yes the error you are getting is probably because you still have to do the following... To Use ODBC, means that the database is residing on the same machine as you are running the application. so you would probably need a DSN configured from the Control Panel.
This means that MySql should provide a ODBC Driver that you will be using to create this DSN, which you can download here
Then you should also check with the Connection URL that you are providing...when you Use the ODBC Driver, then you the URL looks like this..
jdbc dbc:<the DSN Name that you create>
better still is to use the JDBC Driver which will help you avoid all this. [ December 23, 2004: Message edited by: RajaniKanth Bhargava ]