Hi Everyone, I have a bit of a problem connecting to an access Database using JDBC/ODBC bridge. To make sure my datasource setup is right, I connected and populated the database by using an ASP code, but when I use Java to connect to the database it give an Exception error. Do I need to download a special driver? Please any help would be greatly appreciated.This the code below: import java.io.*; import java.lang.String; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; import java.sql.Driver;
"tapenten", The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please log in with a new name which meets the requirements. Thanks.
I had similar error using jdbc/odbc driver to connect with a Microsoft Access database from a servlet, though it works fine as standalone java class. Remember that MSAccess doesn't allow network access. You need to set up an RMI object. Go here for instructions on how to do this: http://www.objectweb.org/RmiJdbc/Access/access.html g'luck