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 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 Android Security Essentials Live Lessons this week in the Android 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: 41124
    
  45
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 - my free Android networking tools app
King Chin
Greenhorn

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

The linked you provided is really helping me.

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