Using Tomcat 4.0 to connect to MS Access DB

["Michael J. Pierzga" <mj...@psu.edu>]

Hello all,

I have been using Apache with Tomcat 3.2 to simply use a MS Access 
database. I connect the datasource name to the actual file using the ODBC 
service administrator from the Windows NT control panel. Now, I want to go 
to Tomcat 4.0 stand-alone and get to the same database ... everything sets 
up fine, I get to my servlet, but get errors when I try to connect ....

The error is,
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name 
not found and no default driver specified

Seems like the ODBC service administrator and Tomcat are not sharing the 
datasource name. What do I need to do to get 4.0 working? I have not 
established any new realms or resources via the server.xml file  - do I 
need to?

Thanks for any leads.

Mike Pierzga