I am building a web application and I need a connection between the Model class and a MS Access database. I have tested it using JDBC DBC bridge for prototyping. However as my WAR file(containing the model class) is going to be placed on a remote server and my database on another machine, I need to install a type 3 driver. I am limited to using MS access. Any suggestions on how to use and install the driver?
I am planning to make an WAR file sitting on a webserver to talk to the Access DB. Using struts for the front end controller. Please correct me if my approach to the application is wrong.
I'm not sure what it needs to be a type 3 driver -which requires special software to be installed on the server-; I think a type 4 would be more appropriate. A list of possible drivers can be found here. [ January 25, 2006: Message edited by: Ulf Dittmer ]