JDBC for SQL Server - Herong's Tutorial Examples - v3.14, by Herong Yang
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
JDBC (Java Database Connectivity) Introduction
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
Using Connection Pool with JDBC
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