• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC driver for MS Access (Linux)

 
Tim Bee
Ranch Hand
Posts: 91
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2588
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ulf Dittmer
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic