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 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 Android Security Essentials Live Lessons this week in the Android 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: 41173
    
  45
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
 
Similar Threads
Merge Data in MS Word on UNIX platform
Accessing Data from MS-Access database
Connecting to Unix via Windows
Export into file, sql query to insert data
Connecting to MsAccess from an Unix machine throught Java