I am trying to access an ms access database. Have already setup the system dsn. i am able to access the database through a java file but not through the jsp and servlets.
below is the code i use to connect to the database:
You're using the JDBC-ODBC bridge, which is an unsupported driver and only included in the Sun JVM. Looks like you are using the IBM JDK.
Personally I suggest getting away from MS Access. Seriously. It may not be solution you're looking for, but I'd prefer to offer a real solution to a patch on something going wrong.
... not to mention that Access wasn't meant for concurrent access, so all kinds of things could be going wrong in a multithreaded environment like a web app.
F is for finger. Can you stick your finger in your nose? Doesn't that feel nice? Now try this tiny ad:
a bit of art, as a gift, the permaculture playing cards