aspose file tools*
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
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: 42628
    
  65
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: read data from MS Access db file in UNIX, using JAVA