Error in JDBC ODBC

[Arun Somasundaram]

Hi i am getting the following exception when i run the login.jsp. I use JDBC ODBC bridge driver to connect to the database.The database I use is MS Access.There is no error in jsp but still I am getting the exception

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Here is the source cose for login.jsp:-

  
 
<%@ page language="java" session="true" errorPage="error.jsp" import="java.io.*,java.sql.*" %>
 
<%
 
Connection con = null;
Statement st = null;
ResultSet rs = null;
 
String username = request.getParameter("id");
String password = request.getParameter("passwd");
 
try
{
 
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:forum");
st = con.createStatement();
rs = st.executeQuery("select id,uname,password from users");
 
while(rs.next())
{
 
if(username.equals(rs.getString(2)) && password.equals(rs.getString(3)))
{
session.setAttribute("uid",username);
session.setAttribute("id",rs.getString("id"));
response.sendRedirect("/examples/jsp/forum.jsp");
}
 
}
 
response.sendRedirect("login.html");
 
}
 
catch(Exception e)
{
out.println(e);
}
 
%>
 

I set the user DSN name as forum.

Any one Help me to come out of this problem.

[Muhammad Saifuddin]

Originally posted by Arun Somasundaram:

I set the user DSN name as forum

Create your DataSource with System DSN this is the next tab of user DSN in
ODBC DataSource Administration..
[ October 11, 2006: Message edited by: Saif Uddin ]