Hello. I apologize if this has been addressed a million times before. I'm relatively new to Java, but not new to programming or MySQL.

I installed the mm.mysql classes on my machine and CAN connect to MySQL tables and work with them.....but only when I write a java app that's running locally. When I create an applet, IE5.5 and Netscape both give the dreaded 'No Suitable Driver' error when I try to connect to the db. Here's some of my code:

--------------------------------- try { Class.forName("org.gjt.mm.mysql.Driver").newInstance(); } catch (SQLException E) { //print error msgs. }

try { CONNECTION C = DriverManager.getConnection("jdbc:mysql://path/to/MySQL_db?user=xxxx&passwor d=xxxx"); Statement S = C.createStatement(); ResultSet RS = S.executeQuery("SELECT * FROM...."); // etc..... } catch (SQLExceiption E) { //print errors. }

-----------------------------------------

I suspect that there's a system setting that wrong. Any help would be greatly appreciated. TIA.

Dave E.