how to integrate ms access and mysql together

[najmi]

hai,

i have one problem to integrate ms access and mysql together using jsp.my error is it can not find the driver for mysql..here is my code

<%@ page import="java.sql.*" %>
 
<%
   Connection odbcconn = null;
   Connection jdbcconn = null;
   PreparedStatement readsms = null;
   PreparedStatement updsms = null;
   ResultSet rsread = null;
 
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//load database driver
   odbcconn = DriverManager.getConnection("jdbc:odbc:SMS");//connect to database
   readsms = odbcconn.prepareStatement("select * from inbox where Status='New'");
   rsread = readsms.executeQuery();
   while(rsread.next()){
        Class.forName("com.mysql.jdbc.Driver");
        jdbcconn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bakme", "root", "");//connect to database
        updsms = jdbcconn.prepareStatement("insert into inbox(sms,phone) values (?,?)");
        updsms.setString(1, rsread.getString("Message"));
        updsms.setString(2, rsread.getString("Phone"));
        updsms.executeUpdate();
   }
 
%>

[najmi]

i have solved this problem by adding driver in library