Alright, i am now using "org.gjt.mm.mysql.Driver"
However, I am getting an error 500: NullPointerException.
My code is as follows:
------
Class.forName("org.gjt.mm.mysql.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost/webDB","admin","******");
------
Everything works fine when I switched back to my old driver using Access as my database:
------
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("JDBC:ODBC:NapDB","","");
------
This inicates that the rest of my code should be OK and that the problem has something to do with the mySQL. With my old setup, my servlet knows where to locate my database because I told the system where it is during the ODBC setup. In MySQL, how does the servlet know where to find my database? I am a newbie to JSPs, Servlets, and MySql! Could I be missing some steps? What i did was I installed MySQL. Then I installed mysqld-nt as a service. Started the service. Populated the database. Gave it a username and password.
!["" "[confused]"]("graemlins/confused.gif")