accessing ms. access

[newbiejava]

Dear All.

I want to open read & write ms. access in Linux & Windows Environment..
could any body please advise.. where can I download free version of Ms. Access JDBC ?

TIA

[wsaryada]

Hello,

You can use the Sun JDBC ODBC Driver (sun.jdbc.odbc.JdbcOdbcDriver) to access and manipulate the Microsoft Access database.

[newbiejava]

Hi thanks,

could you please give me a simple example for opening Ms. Access DB?

currently, I am trying to use Jackless (Jackcess - Java Library for MS Access) .. but facing problem

TIA

[wsaryada]

Hello,

Here is an example that I have for opening connection to MS Access database:

package org.kodejava.example.sql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.PreparedStatement;

public class MSAccessConnect {
    //
    // If you want to use you ODBC DSN
    //
    //private static final String URL = "jdbc:odbc:TestDB";

    private static final String USERNAME = "admin";
    private static final String PASSWORD = "welcome";
    private static final String DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";

    private static final String URL =
        "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\Database\\testdb.mdb;}";

    public static void main(String[] args) throws Exception {
        Connection connection = null;
        try {
            Class.forName(DRIVER);
            connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);

            //
            // Do something with the connection here!
            //
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            connection.close();
        }
    }
}

The code is taken from How do I create a connection to MS Access database?

[newbiejava]

ok, I understood now.. so I should create DSN..
does the codes also compatible on Linux? ..

[newbiejava]

Thanks, wsaryada .. it works!

Regards