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

How Do I Troubleshoot A Failed JDBC-ODBC Bridge Connection?

  1. Insure that the ODBC Data Source Name connects to the target database.
  2. Insure that Windows-based ODBC Data Sources are System Data Sources.
  3. Insure that OpenLink's Single-Tier driver is installed on the machine that contains the ODBC Data Source Name.
  4. Insure that you pass the exact name of the ODBC Data Source in the JDBC connection URL.
  5. Insure that your Single-Tier JDBC connection URL uses the following syntax:
    jdbc:openlink://ODBC[/DSN][/UID][/PWD][/READONLY]
    
    For example:
    jdbc:openlink://ODBC/DSN=Local Oracle ODBC/UID=scott/PWD=tiger