Hi Friend,

Your code haven't found the Data Source Name(DSN) of the connection. Therefore it throws NullPointerException.

Use the following code where 'access' is my data source name:

<%@ page import ="java.io.*"%>
<%@ page import ="javax.servlet.*"%>
<%@ page import ="javax.servlet.http.*"%>
<%@ page import ="java.sql.*"%>
<% Connection conn=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn =DriverManager.getConnection("jdbc:odbc:access","","");

}
catch(Exception ex)
{
ex.printStackTrace();
}

Statement st=conn.createStatement();
ResultSet rs=st.executeQuery("select * from subject");
while(rs.next())
{
out.println(rs.getString("name"));
}
%>
Thanks