JDBC-ODBC - Connecting to MS Access Database Files

<< JDBC-ODBC Bridge Driver - MS Access

<< JDBC Tutorials - Herong's Tutorial Notes

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) 2007 by Dr. Herong Yang. 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:

C:\>javac OdbcAccessConnection.java

C:\>java OdbcAccessConnection
Connection ok.

Sections in This Chapter

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