aspose file tools*
The moose likes JDBC and the fly likes Connecting to MsAccess from an Unix machine throught Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connecting to MsAccess from an Unix machine throught Java" Watch "Connecting to MsAccess from an Unix machine throught Java" New topic
Author

Connecting to MsAccess from an Unix machine throught Java

King Chin
Greenhorn

Joined: Aug 13, 2008
Posts: 11
Can any one advise me how to connect to an MS access from Unix using Java.

I have the MS acces file in windows platform.

Advance Thanks
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

I don't know of any wrapper for the native libraries Access uses available for UNIX, and Access doesn't provide support for standard protocols. Two ideas: write a wrapper application on your Windows machine that is backed by Access and talk to that instead, or use a database that is supported on UNIX and also has linking capabilities with Access (MySQL can do this I think).

The best idea though would be to export your schema from access and recreate it in a different database.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
King Chin
Greenhorn

Joined: Aug 13, 2008
Posts: 11
Thank you Paul.

What do you suggest, if I have the MS access file in my Unix machine(FTP ed ). How could I create a DSN to be used in the default JDBC-ODBC driver provided along with Java JDK.

Advance Thanks
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 39576
    
  27
Unix-ish OSes generally don't have ODBC, so you'll need to use a different driver than the JDBC/ODBC bridge. Check out http://www.hxtt.com/access.html

Or have a look at http://www.unixodbc.org/, which purports to support ODBC on Unix.


Ping & DNS - updated with new look and Ping home screen widget
King Chin
Greenhorn

Joined: Aug 13, 2008
Posts: 11
Thank you Ulf.

The linked you provided is really helping me.

Thanks once again.
 
wood burning stoves
 
subject: Connecting to MsAccess from an Unix machine throught Java
 
Similar Threads
whats wrong in my DD ?
How to connect to MS - Access from Java
read data from MS Access db file in UNIX, using JAVA
package
Create Excel Speedsheet on UNIX