Connect MS-Access using jdbc-odbc in Windows 7 64-bit

Connect MS-Access using jdbc-odbc in Windows 7 64-bit

I faced this problem while connecting to MS-Access using JDBC-ODBC driver, on my laptop and found out this solution.

Bye-the-way I received the following error initially(in my output console).

Exception: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

My solution as follows…

Step 1

Run the 32-bit odbc driver using

WinKey+R, then copy-paste the below command

C:\Windows\SysWOW64\odbcad32.exe
Step 2

Make a dsn named “AccessDB” or whatever name you want to.

Step 3

Create a new project in eclipse.

Step 4

Change the jre to the java installed inside

C:\Program Files (x86)\java

Use this as “JRE System Library”

Step 5

Use the below code to connect to connect mdb file named “library.mdb”(choose ur mdb file), having the path as

“D:\Study\library.mdb”

import java.sql.Connection;
import java.sql.DatabaseMetaData;

public class Main {

    /**
     * @param args
     */
    public static void main(String[] args) {
        // TODO Auto-generated method stub
        Connection con = null;
        try {

    // Setting up the DataSource object
          sun.jdbc.odbc.ee.DataSource ds
            = new sun.jdbc.odbc.ee.DataSource();
          ds.setDatabaseName("AccessDB");
          ds.setDataSourceName("D:\\Study\\library.mdb");
    // Getting a connection object
          con = ds.getConnection();

    // Getting database info
          DatabaseMetaData meta = con.getMetaData();
          System.out.println("Server name: "
            + meta.getDatabaseProductName());
          System.out.println("Server version: "
            + meta.getDatabaseProductVersion());

    // Closing the connection
          con.close();
        } catch (Exception e) {
          System.err.println("Exception: "+e.getMessage());
        }
      }
}

Viola…
Output
Server name: ACCESS
Server version: 04.00.0000

(for any clarification, do ask in my blog, I’ll be happy to explain)…

peace out…