Regarding Servlet connectivity with ms-access

[sharma sachin]

Hello
I have created one simple Servlet file that insert the records in the database
I have used ms-access as back-end but when I try to insert the records it is giving an exception
that no data source name or default odbc driver not found
however same thing works when I try to insert the records using main() method on console
(means same concept works properly when I try to insert the records using swing form)
but using servlet it is giving an exception

Can anyone solve my query???

[amit punekar]

Hi,
How are you connecting to the datasource? I presume you must be using JDBC_ODBC driver, can you please share the part of the code that connects to the database?
Also post the exception. After looking at it we might be able to get some clue.

regards,
amit

[sharma sachin]

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


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


   String n1=req.getParameter("uname");
   String n2=req.getParameter("uid");


   try
    {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection con=DriverManager.getConnection("jdbc:odbc:hello");

      PreparedStatement pstmt=con.prepareStatement("insert into myTable values(?,?)");
      pstmt.executeUpdate();
      con.close();
      pstmt.close();
    }

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

the above code generates an exception:
exception=java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

however same dsn works while connecting the swing form with MS-ACCESS
means data is inserting successfully while using the swing form

[anirudh jagithyala]

Did you create user DSN with only name hello and select the corresponding .mdb database....

PreparedStatement pstmt=con.prepareStatement("insert into myTable values(?,?)");
pstmt.executeUpdate();

The prpared statement needs to be given values before its executed....
add

pstmt.setString(1,n1);
pstmt.setString(2,n2);

between line 24 and 25


If you are using vista sometimes you would get driver problems , i had a similar issue which worked in other windows OS but not vista
try updating drivers.


..........................................

[Muhammad Saifuddin]

Lets start debugging to find where this little code giving you an stupid error.

To create and DSN please follow 'Control Panel ->Administrative tools ->Data Sources(ODBC) ->System DSN ->Add'
and make sure to create system DSN instead of user.

String className = "sun.jdbc.odbc.JdbcOdbcDriver";
Class driverObject = Class.forName(className);
output.append("Driver : "+driverObject+"\n");
output.append("Driver Installation Successful");
Connection con=DriverManager.getConnection("jdbc:odbc:hello");  

if(con!= null){
   System.out.println("Got Connection.");
   DatabaseMetaData meta = con.getMetaData();
   System.out.println("Driver Name : "+meta.getDriverName());
   System.out.println("Driver Version : "+meta.getDriverVersion());
}else{
   System.out.println("Could not Get Connection");
}