JDBC-ODBC - Connecting to a DSN

This section describes how to connect to a DSN (Data Source Name) with JDBC-ODBC Bridge.

After I have my DSN, HY_DSN, created to represent a flat text file, now I am going to try to connect my Java program to this DSN 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 DSN with JDBC-ODBC Bridge:

/* OdbcDsnConnection.java
 * Copyright (c) HerongYang.com. All Rights Reserved.
 */
import java.sql.*;
public class OdbcDsnConnection {
  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_DSN");
      System.out.println("DSN Connection ok.");
      con.close();

    } catch (Exception e) {
      e.printStackTrace();
    }
  }
}

The output confirms that the connection method worked correctly:

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

herong> progra~1\java\jdk1.7.0_45\bin\java OdbcDsnConnection
DSN 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 Features

 JDBC-ODBC - Loading sun.jdbc.odbc.JdbcOdbcDriver

 JDBC-ODBC - Creating DSN

JDBC-ODBC - Connecting to a DSN

 JDBC-ODBC - Problem with Incorrect DSN

 JDBC-ODBC Bridge Driver - Flat Text Files

 JDBC-ODBC Bridge Driver - MS Access

 JDBC-ODBC Bridge Driver - MS SQL Server

 Archived Tutorials

 References

 Full Version in PDF/EPUB