a easy question please help !!!

how can I access microsoft access2000 in jsp
this is my code
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
java.sql.Connection sqlConn;
java.sql.Statement sqlStmt;
java.sql.ResultSet sqlRst;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
sqlConn=java.sql.DriverManager.getConnection("jdbc.odbc.people");
sqlStmt=sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
sqlRst=sqlStmt.executeQuery("select name,age from people");
%>
<html>
<head>
<title>JDBC ACCESS 测试<title>
</head>
<body>
<table border="1" cellspacing="0" align="center">
<tr>
<th>姓名<th>
<th>年龄</th>
</tr>
<%while(sqlRst.next()){%>
<tr>
<td><%=sqlRst.getString(1)%></td>
<td><%=sqlRst.getLong(2)%></td>
</tr>
<%}%>
</table>
</body>
</html>
<%
sqlRst.close();
sqlStmt.close();
sqlConn.close();
%>

but tomcat says "no suitable driver"

David,
I'm sure you figured out an answer to your question and I'm not even certain this will help you out since it's Java and not JSP, but figured I would share some beginner code I have been creating for a training plan which might give you some pointers? The following code does successfully attach to an Access 2000 DB from within JDK 1.4.1 using a User DSN:

import java.sql.*;
public class DataBaseSelectCoffeeA
{
    public static void main(String args[])
    {
// declare variables for the data
String cof_name;
// String cof_price;
double cof_price;
// declare driver string
String sdriver= "sun.jdbc.odbc.JdbcOdbcDriver";
// define the Connection
Connection con = null;
// declare url for the database
String url = "jdbc :-o	 dbc:JavaTraining";  // The dB name="JavaTrainingDB, the user dsn=JavaTraining"
// declare the statement object
Statement stmt=null;
// define the SQL query statement
String sqlQuery = "SELECT * from Coffee where Price>8.00 and Cof_Name like 'F%' ";
try
{
// load the jdbc - odbc bridge driver for Windows-95
    Class.forName(sdriver).newInstance();
}
catch (Exception e)//error
{
System.err.println("Failed to load current driver");
return;
}
try
{
// create connection instance
    con = DriverManager.getConnection(url);
    // create statement object instance
    stmt = con.createStatement();
}
catch (Exception e)
{
System.err.println("Problems connecting to " + url + ":");
System.err.println(e.getMessage());
if (con != null)
{
try {con.close();}
catch(Exception e2) {}
}
return;
}//end connection catch
try
{
    System.out.println ("Query of Coffee where Price > $8 and name like F");
    // execute the SQL query statement
    ResultSet rs = stmt.executeQuery(sqlQuery);
    // set the cursor & get first row
    boolean more = rs.next();
    if (more!=true)
    {
System.out.println("\nno rows of data for report");
    }
    else
    {
    while (more) // loop while there are rows of data
    {
// extract the data & display
cof_name = rs.getString("Cof_Name");
cof_price= rs.getDouble("Price");
//cof_price= rs.getfloat(3);
System.out.println(cof_name + "     " + cof_price);
// get next row
more = rs.next();
    } // end while loop
System.out.println("\n ===>End of Report");
rs.close();// close everything
}// end if more !=true
    } // end rs try
catch (Exception e)
{
e.printStackTrace();
}
finally
{
try
{
stmt.close();
}
catch (Exception e) {}
try
{
con.close();
}
catch (Exception e) {}
}//end of finally
  } // end main
} // end DataBaseSelectCoffeeA.java

Remember, it's meant as a training tool! Hope this helps!
Janet