File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and Relational Databases and the fly likes read data from MS Access db file in UNIX, using JAVA Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Groovy Fundamentals video training course this week in the Groovy forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "read data from MS Access db file in UNIX, using JAVA" Watch "read data from MS Access db file in UNIX, using JAVA" New topic
Author

read data from MS Access db file in UNIX, using JAVA

premchand chand
Greenhorn

Joined: May 07, 2008
Posts: 6
We have a requirement to read data from MS Access db file in UNIX, using JAVA.

Could someone provide any pointer how to go about it?



I was trying to use the below but was failing on UNIX:



Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String database = "jdbcdbcriver={Microsoft Access Driver (*.mdb)};DBQ=";

database += this.fileName.trim() + ";DriverID=22;READONLY=true}";

this.con = DriverManager.getConnection(database ,"","");

this.stmt = this.con.createStatement();


Ulf Dittmer
Rancher

Joined: Mar 22, 2005
Posts: 42956
    
  73
Unix/Linux does not support ODBC out of the box; see http://www.unixodbc.org/ for how to get it working.

Alternatively, a type 4 driver for Access is available: http://www.hxtt.com/access.html

If you don't require JDBC, check out the Jackcess library on SourceForge.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: read data from MS Access db file in UNIX, using JAVA