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.

Table of Contents

 About This Book

 JDBC (Java Database Connectivity) Introduction

 JDK (Java SE) Installation

 Microsoft SQL Server Express Edition

 Microsoft JDBC Driver for SQL Server

 Microsoft JDBC Driver - Query Statements and Result Sets

 Microsoft JDBC Driver - DatabaseMetaData Object

 Microsoft JDBC Driver - DDL Statements

 Microsoft JDBC Driver - DML Statements

 SQL Server - PreparedStatement

 SQL Server CLOB (Character Large Object) - TEXT

 SQL Server BLOB (Binary Large Object) - BLOB

 JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver

 JDBC-ODBC Bridge Driver - Flat Text Files

JDBC-ODBC Bridge Driver - MS Access

 JDBC-ODBC - Creating a MS Access Database File

 JDBC-ODBC - Creating DSN for MS Access

JDBC-ODBC - Connecting to MS Access Database Files

 JDBC-ODBC - MS Access Database and Driver Info

 JDBC-ODBC - Creating New Tables in MS Access Database

 JDBC-ODBC - Inserting Data Rows to MS Access Database

 JDBC-ODBC - Running Queries on MS Access Database

 Creating Connections with DataSource Class

 JDBC-ODBC Bridge Driver - MS SQL Server

 Archived Tutorials

 References

 Full Version in PDF/EPUB