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…

Advertisement