aspose file tools*
The moose likes JDBC and the fly likes JDBC driver for MS Access (Linux) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC driver for MS Access (Linux)" Watch "JDBC driver for MS Access (Linux)" New topic
Author

JDBC driver for MS Access (Linux)

Tim Bee
Greenhorn

Joined: Apr 30, 2007
Posts: 1
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.

Thanks,
Tim
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2476
    
    7

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.

Regards, Jan


OCUP UML fundamental and ITIL foundation
youtube channel
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 39537
    
  27
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.


Ping & DNS - updated with new look and Ping home screen widget
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC driver for MS Access (Linux)
 
Similar Threads
JDBC Connection to MS Access DB without ODBC
Remote Access
Java WebServices vs Delphi web services
Type -3 JDBC driver : Network-Protocol Driver
type 4 jdbc driver