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