Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connecting to MsAccess from an Unix machine throught Java

 
King Chin
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
King Chin
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
King Chin
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Ulf.

The linked you provided is really helping me.

Thanks once again.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic