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