JdbcOdbc Connect : JDBC ODBC « Database SQL JDBC « Java

JdbcOdbc Connect


import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;

public class JdbcConnect {

  public static void main(String[] args) throws Exception {
    Connection conn1 = null;
    Connection conn2 = null;
    Connection conn3 = null;

    String jdbcUrl = "jdbc:odbc:authors";

    String user = "yourName";
    String pwd = "mypwd";

    conn1 = DriverManager.getConnection(jdbcUrl);
    if (conn1 != null) {
      System.out.println("Connection 1 successful!");
    Properties prop = new Properties();
    prop.put("user", user);
    prop.put("password", pwd);

    conn2 = DriverManager.getConnection(jdbcUrl, prop);
    if (conn2 != null) {
      System.out.println("Connection 2 successful!");
    conn3 = DriverManager.getConnection(jdbcUrl, user, pwd);
    if (conn3 != null) {
      System.out.println("Connection 3 successful!");
    if (conn1.isClosed()) {
      System.out.println("Connection 1 is closed");

    if (conn2.isClosed()) {
      System.out.println("Connection 2 is closed");
    if (conn3.isClosed()) {
      System.out.println("Connection 3 is closed");




Related examples in the same category

1.jdbc:odbc bridge
2.jdbc odbc bridge connection string
3.Simple example of JDBC-ODBC functionality
4.Using a PreparedStatement through sun.jdbc.odbc.JdbcOdbcDriver
5.Creating and using a stored procedure with sun.jdbc.odbc.JdbcOdbcDriver
6.Retrieving a ResultSet from JdbcOdbcDriver
7.Getting an output parameter from a stored procedure
8.Opening an updatable ResultSet
9.Using ResultSetMetaData from jdbc:odbc
10.Creating a table using JdbcOdbcDriver
11.Using INSERT with JdbcOdbcDriver
12.Using UPDATE with JdbcOdbcDriver
13.Creating and dropping indexes
14.Using DSN-less connection