I know from previous experience that driver you show is horribly outdated, and 
horrible in general.

I assume no credentials are needed to access the DB in the Connection  object, 
con?

Maybe I'm reading that incorrectly.

Does the JDBC program connect to MS Access at all?


-----Original Message-----
From: RAHUL RAJ [mailto:omrahulraj...@gmail.com]
Sent: Friday, April 15, 2011 5:05 AM
To: users@tomcat.apache.org
Subject: Working of Tomcat with MS Access

Hello,
     I am working on  building a jsp website with MS Access as database. When 
my login page is loaded on tomcat (localhost:8080/login.jsp), it shows the 
following error:

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

The jdbc program alone is working perfectly, So There might not be problems due 
to  Driver, Data source name, Database Tables or any other software version 
compatibilities.

OS: Windows Vista Home Basic
Tomcat Version: 5.5.x
jdk version: 1.6
MS Access 2010


code is given below:

<%@ page language="java" import="java.sql.*" %>  <html>  <body>  <form 
method="post">  <p> Enter your username :  <input type="text" name="username"/> 
</p>  <p> Enter your password :  <input type="text" name="password"/> </p>  
<input type="submit" value="Login"/>  <%
    String usn = request.getParameter("username");
        String pass = request.getParameter("password");

        try{
                 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                 String url = "jdbc:odbc:rahul";
                 Connection con = DriverManager.getConnection(url, "", "");
                 Statement s = con.createStatement();

                 ResultSet rs = s.executeQuery("select * from customers");
                 while(rs.next())
                 {
                   String u = rs.getString(1);
                   String p = rs.getString(2);
                   if(usn.equals(u) && pass.equals(p))
                   {
                      out.println("login successfull");
                          }
                   else
           {
              out.println("login failed");
             }
           }
        }

                catch(Exception e)
                {
                   out.println("Error"+e);
                   }

 %>
 </form>
 </body>
 </html>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

Reply via email to