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) 2007, 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:

C:\>javac OdbcSqlServerConnection.java

C:\>java OdbcSqlServerConnection
First connection ok.
Second connection ok.

Last update: 2007.

Table of Contents

 About This Book

 JDBC (Java Database Connectivity) Introduction

 JDK (Java SE) Installation

 Installing and Running Java DB - Derby

 Derby (Java DB) JDBC Driver

 Derby (Java DB) JDBC DataSource Objects

 Java DB (Derby) - DML Statements

 Java DB (Derby) - ResultSet Objects of Queries

 Java DB (Derby) - PreparedStatement

 MySQL Installation on Windows

 MySQL JDBC Driver (MySQL Connector/J)

 MySQL - PreparedStatement

 MySQL - Reference Implementation of JdbcRowSet

 MySQL - JBDC CallableStatement

 MySQL CLOB (Character Large Object) - TEXT

 MySQL BLOB (Binary Large Object) - BLOB

 Oracle Express Edition Installation on Windows

 Oracle JDBC Drivers

 Oracle - Reference Implementation of JdbcRowSet

 Oracle - PreparedStatement

 Oracle - JBDC CallableStatement

 Oracle CLOB (Character Large Object) - TEXT

 Oracle BLOB (Binary Large Object) - BLOB

 Microsoft SQL Server 2005 Express Edition

 Microsoft JDBC Driver for SQL Server - sqljdbc42.jar

 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

 Summary of JDBC Drivers and Database Servers

 Additional Tutorial Notes to Be Added

 Outdated Tutorials

 References

 PDF Printing Version