I'm looking for a free JDBC driver that will allow me to acces a MS Access database that resides on a Windows server from a JSP application that resides on a Redhat Linx server. Any suggestions would be appreciated.
Ms Access is not client /server, but uses your windows filesystem to access it's data. Accessing it from a linux machine is not straightforward.
There is a software package, RmiJdbc, that turns your access database into a client/server architecture. The package includes a jdbc driver that works on linux. The access instructions are documented on their site.
OCUP UML fundamental
Joined: Mar 22, 2005
If you have file system access to the MDB file, you can use Jackcess. It's not JDBC, though, but instead implements its own API.