Q1 : I am trying to create a quick demo using JSP to access database. I am using Microsoft Access. I know that I need to put the driver jar file in the WEB-INF/lib directory. Where can I get the driver jar file or the driver class file for Microsoft Access ? If I have the driver class file where should I put it.
Q2 : It is said that sun.jdbc.odbc.JdbcOdbcDriver is included in the JDK but where is it included. Is there anyway that I can see it in the hard drive after I install the JDK.
If you use free jdbc-odbc bridge driver, you needn't to set WEB-INF/lib, but your web host should be Windows OS.
Joined: Sep 18, 2006
Thanks Nelson and Wei. I have extracted the rt.jar and found the JdbcOdbcDriver.class file. Can I just copy this file into the WEB-INF/classes directory.
Wei, I have browse to the site at www.hxtt.com but it looks like I have to pay to get the driver. Wei, I am not sure what you meant by " If you use free jdbc-odbc bridge driver, you needn't to set WEB-INF/lib, but your web host should be Windows OS " Do you mean if I run Tomcat on windows XP than I don't need to put the driver jar file in the lib directory.
Joined: Jun 22, 2005
>Do you mean if I run Tomcat on windows XP than I don't need to put the driver > jar file in the lib directory. Yeah. rt.jar can be visited by Java VM in default. You need a dsn-less JDBC url, for instance,