JDBC-ODBC - Connecting to MS Access Database Files

JDBC for SQL Server - Herong's Tutorial Examples

∟JDBC-ODBC - Connecting to MS Access Database Files

This section describes how to connect to a SQL Server 2005 through DSN with JDBC-ODBC Bridge.

After I have my MS Access database file and my DSN representing this file created, I can try to connect my Java program to my MS Access database with JDBC-ODBC Bridge using the DriverManager.getConnection() method:

DriverManager.getConnection("jdbc:odbc:dsn_name");

Here is my sample program showing you how to connect to my Access database file with JDBC-ODBC Bridge:

/* OdbcAccessConnection.java
 * Copyright (c) HerongYang.com. All Rights Reserved.
 */
import java.sql.*;
public class OdbcAccessConnection {
  public static void main(String [] args) {
    Connection con = null;
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;

// Connect with a url string
      con = DriverManager.getConnection("jdbc:odbc:HY_ACCESS");
      System.out.println("Connection ok.");
      con.close();

    } catch (Exception e) {
      System.err.println("Exception: "+e.getMessage());
    }
  }
}

The output confirms that the connection method worked correctly:

herong> progra~1\java\jdk1.7.0_45\bin\javac
   OdbcAccessConnection.java

herong> progra~1\java\jdk1.7.0_45\bin\java OdbcAccessConnection

Connection ok.