Meaningless Drivel is fun!*
The moose likes JDBC 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 OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
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
Marshal

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


Ping & DNS - my free Android networking tools app
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: read data from MS Access db file in UNIX, using JAVA