Installation Guide: OpenLink ODBC to JDBC Bridge Connector (Driver) for Windows (Enterprise Edition)

OpenLink · October 27, 2025, 1:28pm

This installation guide walks you through installation of the Enterprise Edition ODBC to JDBC Bridge Driver to a Personal or Application Server host functioning as a client to a database that’s accessible via its native JDBC Driver.

Step 1: Download the Installer Archive

Visit the OpenLink ODBC Enterprise Edition Driver Download Page to download the appropriate ODBC to JDBC Bridge Driver.
Alternatively, curl can be used to download the installer archives and install.sh script directly:

curl -O https://download3.openlinksw.com/uda/components/9.0/x86_64-generic-win-64/waajzzzz.msi
curl -O https://download3.openlinksw.com/uda/components/9.0/x86_64-generic-win-64/wabrzzzz.msi
curl -O https://download3.openlinksw.com/uda/components/9.0/x86_64-generic-win-64/wao3zzzz.msi

Step 2: Pre-Installation Configuration

A 64-bit JVM must be installed and configured.
A third-party or native JDBC drivers that connects to the target database must be available
The JDBC Driver must be installed on the same machine as the Multi-Tier “Enterprise” Edition Request Broker and Bridge Agent(s) for JDBC Data Sources.
The JDBC driver jar file (or a symbolic link to it) must be included in the active CLASSPATHenvironment variable.
The JDBC driver class name must be known.
The JDBC connection URL that connects to your target JDBC Data Source must be known.
The location of the jvm.dll shared library DLL used by the OpenLink JDBC Bridge agent must be set in the PATH environment variable
Generally, the latest JVM from http://java.com/ is the best choice.

Step 3: Installation

Log onto the target machine for the installation
Copy or downloaded all windows MSI installers to the target machine, which are the waajzzzz.msi, wabrzzzz.msi, wao3zzzz.msi MSI files.
Run each MSI installer to install the client and server components of the Enterprise Multi-Tier ODBC-JDBC Bridge.
Take care to enter correct information when prompted pertaining to ports, passwords, etc and ensure that you note these down for future use.
The installation should finish without error.

Step 4: Configuration

The installers would have setup all the environment variables etc required to use the OpenLink drivers, but the Java CLASSPATH for the target JDBC driver and PATH to the jvm.dll Java runtime environment variables can be set in the OpenLink Rule Book (oplrqb.ini) if not already set system wide
In which case open the file {OPENLINK_INSTALL}/bin/oplrqb.ini with a suitable text editor such as notepad.
Locate the [Environment JDBC18] section for setting the driver specific JDBC configuration and edit to reflect your environment, setting the CLASSPATH to the location of the JDBC Driver jar file and the PATH to the location of the jvm.dll shared library determined in Step 2 –

[Environment JDBC18]
CLASSPATH          = {JDBC Driver JAR file}
PATH = {Directory of jvm.dll file}
;; PATCHNULLSIZEOFSQLCHAR = 4096
;; SQL_DBMS_NAME = hugh

Place the License file(s) (oplrqb.lic, jdbc.lic) either purchased or obtain during the evaluation download process in the {OPENLINK_INSTALL}/bin directory.

Step 5: Create Data Source Name (DSN)

Open the ODBC Data Source Administrator program.

Click on the Add button and select the OpenLink Generic ODBC Driver (Unicode)(9.0) driver.

Enter the {ODBC DSN Name} and {Hostname}:{Port Number}, default is localhost:5000 if making a localhost connection.

Select the Domain Jdbc 1.8 , the Database {JDBC Driver Name}, JDBC URL JDBC Connect String URL, Login ID {Username}, Password, Select the Connect now to verify that all settings are correct and click the Next button to verify connection to the target database.