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 and ITIL foundation
posted 10 years ago
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.