• Topic
  • Discussion
  • doc.FAQ.HowDoITroubleshootAFailedJDBC-ODBCBridgeConnection





    • Ensure that the ODBC Data Source Name connects to the target database.
    • Ensure that Windows-based ODBC Data Sources are System Data Sources.
    • Ensure that OpenLink 's Single-Tier driver is installed on the machine that contains the ODBC Data Source Name.
    • Ensure that you pass the exact name of the ODBC Data Source in the JDBC connection URL.
    • Ensure 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 
    


    Single-Tier Installation or Connection Problem

    Multi-Tier Installation or Connection Problem