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

How Do I Configure An JDBC-ODBC Bridge Connection?

Create a Single-Tier JDBC connection URL that passes the following values:

jdbc:openlink://ODBC/DSN=Valid ODBC Data Source/UID=database username/PWD=database password

Here are some examples:

jdbc:openlink://ODBC/DSN=Informix Stores7/UID=informix/PWD=informix

jdbc:openlink://ODBC/DSN=My Oracle DB/UID=scott/PWD=tiger

jdbc:openlink//ODBC/DSN=SQLServer Northwind Database/UID=sa