How to connect to MS Access DB thru servlet?

[Vandys]

Hi all,

I have an MS Access Database. I want to connect to it thru' Servlet. I looked at the FAQ and found a link to this problem. But that is not getting me the result. Can anyone pls. put down some code lines to do this?? I have created a dsn with the name "prix". PLEASE.......

 

[wushutwist]

It makes no difference whether you are using Servlets are plain vanilla Java, the Database Connection Code is the same. Here is some code that I posted a while back for someone with the same question.

String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String dsn = "prix";
String url = "jdbc:odbc:" + dsn;

Connection conn = null;
try {
   Class.forName(driver);
   conn = DriverManager.getConnection(url);
   /* Do your stuff */
}
catch (SQLException sqle) {
   /* SQL Error.  Do your error handling */
}
catch (ClassNotFoundException cnfe) {
   /* Driver not found.  Do your error handling */
}
finally {
   /* Make sure you close the Connection */
   if (conn != null) {
      try {conn.close();}
      catch(Exception e) {}
   }
}

Hope this helps. Wushutwist