Driver for MS Access in java

Question

My requirement is to use MS Access database using java.

What would be the best solution? Should I download and use sun.jdbc.odbc.JdbcOdbcDriver or should I follow the usual way of connecting to Access database by configuring it in WIndows system?

The application will run on Windows system and I am using Ubuntu for development.

What will be the best approach?

I thought the JDBC-ODBC driver was not only included in the default libraries, but is required to connect to a ODBC source, such as MSAccess. I believe you can create a DNS manually as part of the connection String to the JDBC Driver Manager, but since MSAccess stopped working for me on 64bit machines, I've bothered with it and used other DB solutions...so it's been awhile — MadProgrammer
– MadProgrammer, Commented Feb 21, 2014 at 4:33
@MadProgrammer: The client uses MS Access so I cannot help it.Thanks for the reply.. — user2822187
– user2822187, Commented Feb 21, 2014 at 5:24

Durandal · Accepted Answer · 2014-02-21 06:10:38Z

1

The JdbcOdbcDriver would work in JDK7 or below but it was removed in JDK8 and if you're using Ubuntu for development that won't work anyway; the odbc->Jdbc bridge is dependent on Windows.

You can look at a cross-platform solution: UCanAccess. It's at worth looking at with your circumstances.

edited Feb 21, 2014 at 6:10

answered Feb 21, 2014 at 4:38

Durandal

5,6425 gold badges38 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Driver for MS Access in java

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related