.accdb (Access Database) integration with NetBeans Java Program

[Robert James Liguori]

I'm trying to connect to a .accdb database through a Java program and I'm getting this error:

Got an exception!
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Here is the code:

public class App {
    public static void main(String[] args) {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + "C:\\databases\\project.accdb";
            Connection conn = DriverManager.getConnection(url);
            System.out.println("Connection Succesfull");
        } catch (Exception e) {
            System.err.println("Got an exception! ");
            System.err.println(e.getMessage());
        }
    }
}

Note that I was advised against Java 8 and 64 bit, so I'm using JDK 7 and passing this switch: -D32.

But still no dice.

Additionally, I installed this:

Connector/ODBC 5.3.4
http://dev.mysql.com/downloads/connector/odbc/

But I have nothing specified in Maven.

I'm not sure exactly where/how to enable the driver and connection.

Please advise.

-- Robert

[Oscar Vicente]

Hi, i just join the ranch to reply you.

Now, I'm using Java 8 to develop a program with
an accdb file. After a deep search, I find a
library called UCanAccess, so try it. It's not hard
to use and there's enough information on google for it.
Be careful with the dependecies too.

[Muhammad Javad]

import java.sql.*;
public class App {
    public static void main(String[] args) {

     try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" +
            "database.mdb"
            		//"C:\\databases\\project.accdb"
            		//"Access_Example_VBA.accdb"
            ;
            Connection conn = DriverManager.getConnection(url);
            System.out.println("Connection Succesfull");
        } catch (Exception e) {
            System.err.println("Got an exception! ");
            System.err.println(e.getMessage());
        }
    }
}

This works only for *.mdb and not *.accdb .

Used jdk1.6...

[Tim Moores]

Welcome to the Ranch, Muhammad.

After 9 years, it's unlikely that Robert is still waiting for a response.

Note that the JDBC/ODBC bridge was removed from the JDK years ago, and is no longer a viable option (if it ever was - it had a reputation for being buggy, and of course not being thread-safe). Much better options such as https://sourceforge.net/projects/jackcess/, https://github.com/spannm/ucanaccess (both open source) and http://www.hxtt.com/access.html (commercial) exist.