Ask a question?
  • Contact Us
  • Support Case System
  • Support Forum

How Do I Configure An ODBC-JDBC Bridge Connection?

Unix Single-Tier users pass the following values in your ODBC-JDBC Bridge Data Source:

  1. Name - Any Descriptive Title
  2. Database Name - JDBC Driver Name String
       openlink.jdbc3.Driver
    
  3. Options - Functional JDBC connection URL.
       jdbc:openlink://localhost:5000/SVT=Oracle 8.1.x/DATABASE=ORCL/UID=scott/PWD=tiger
    
  4. Username - JDBC Data Source Userid
  5. Existing Environment - Pass the value that corresponds to your JRE version: JDBC 1.1, JDBC 1.2, JDBC 1.3, or JDBC 1.4.
Windows Single-Tier users pass the following values in your ODBC-JDBC Bridge Data Source:
  1. Data Source Name - Any Descriptive Title
  2. JDBC Driver - JDBC Driver Name String
       openlink.jdbc3.Driver
    
  3. URL String - Functional JDBC connection URL.
       jdbc:openlink://localhost:5000/SVT=Oracle 8.1.x/DATABASE=ORCL/UID=scott/PWD=tiger
    
Multi-Tier users pass the following values in your ODBC-JDBC Bridge Data Source Names:
  1. Name - Any Descriptive Title
  2. Domain (a.k.a 'ServerType') - Pass the value that corresponds to your JRE version: JDBC 1.1, JDBC 1.2, JDBC 1.3, or JDBC 1.4.
  3. Hostname - Hostname or IP of the machine that contains OpenLink's server components
  4. Database - JDBC Driver Name String
       openlink.jdbc3.Driver
    
  5. Options - Functional JDBC connection URL.
       jdbc:openlink://localhost:5000/SVT=Oracle 8.1.x/DATABASE=ORCL/UID=scott/PWD=tiger
    
  6. Login ID - Blank