JDBC-ODBC - Connecting to SQL Server 2005

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

After I have my SQL Server configured for TCP/IP connection, and have created a DSN, SQL_SERVER, representing the SQL Server, I can try to connect my Java program to my SQL Server with JDBC-ODBC Bridge using the DriverManager.getConnection() in two ways:

DriverManager.getConnection(
   "jdbc:odbc:dsn_name;user=***;password=***");

DriverManager.getConnection("jdbc:odbc:dsn_name",properties);
   // properties contains "user" and "password"

Here is my sample program showing you how to connect to the SQL Server with JDBC-ODBC Bridge:

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

// Connect with a full url string
      con = DriverManager.getConnection(
        "jdbc:odbc:SQL_SERVER;user=sa;password=HerongYang");
      System.out.println("First connection ok.");
      con.close();

// Connect with a url string and properties
      java.util.Properties prop = new java.util.Properties();
      prop.put("user", "sa");
      prop.put("password", "HerongYang");
      con = DriverManager.getConnection("jdbc:odbc:SQL_SERVER",
        prop);
      System.out.println("Second connection ok.");
      con.close();

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

The output confirms that both connection methods worked correctly:

herong> javac OdbcSqlServerConnection.java

herong> java OdbcSqlServerConnection
First connection ok.
Second 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 Bridge Driver - MS SQL Server

 JDBC-ODBC - Configuring SQL Server for TCP/IP Connection

 JDBC-ODBC - Creating DSN for SQL Server 2005

JDBC-ODBC - Connecting to SQL Server 2005

 JDBC-ODBC - SQL Server and Driver Info

 JDBC-ODBC - Setting Current Database

 JDBC-ODBC - Looping through ResultSet

 Archived Tutorials

 References

 Full Version in PDF/EPUB