jbbc connection error

[vijayrao81]

Hi i am getting this error in jdbc connection....

Is there anybody to help me out of this error........

Jsp ----> servlet ----->Sql Server 2000

i am using tomcat 5.5 and jdk1.5

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

My coding is .............................................

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class Loginpage extends HttpServlet
{

public void doPost(HttpServletRequest req,HttpServletResponse res)
throws ServletException,IOException {
res.setContentType("text/html");
PrintWriter out=res.getWriter();



String username=req.getParameter("username");
String password=req.getParameter("password");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:kumar", "sa","sa");
Statement smt=con.createStatement();
ResultSet rs=smt.executeQuery("select * from login where username='"+username+"'and password='"+password+"' ");
if(rs.next())
{
out.println("valid user");
}
else
{
out.println("Invalid User");
}

}catch(Exception e)
{
out.println(e);
}
}
}

[r035198x]

1.) Please use code tags when posting code
2.) Did you create the datasource then?

[karthickkuchanur]

Whether u specify the dsn name in odbc