Connecting to MsAccess from an Unix machine throught Java

[King Chin]

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]

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]

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]

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]

Thank you Ulf.

The linked you provided is really helping me.

Thanks once again.