Java EE (Java Enterprise Edition) General Discussion

Hi There,

I don't have a clue why this is not working.

I've created a small application using JSP, Tomcat version 4 and MS Access 2000 as the backend database on a windows 2000 professional system. When I start the Tomcat server as a standalone server, the application works fine - connecting to the database successfully.

I've now managed to get Tomcat 4 running as a service under windows 2000 after installing the JavaService utility recommended from Apache's website. Unfortunately my application doesn't seem to work/connect with the backend database when Tomcat is running as a service. I've tested other JSP scripts such as Tomcat's example to check that the JSP pages are being invoked and they do work fine. (Note: None of Tomcat's examples involve database connection).

The code that I use for all database connection are as follows

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:KIMS";
con = DriverManager.getConnection(url);

Please could anyone help. Much appreciated!!!

Regards
Assad