my dog learned polymorphism*
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 39547
    
  27
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 - updated with new look and Ping home screen widget
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: read data from MS Access db file in UNIX, using JAVA
 
Similar Threads
Accessing Data from MS-Access database
Merge Data in MS Word on UNIX platform
Connecting to MsAccess from an Unix machine throught Java
Export into file, sql query to insert data
Connecting to Unix via Windows