This installation guide walks you through installation of the Enterprise Edition ODBC to ODBC Bridge Driver to a Personal or Application Server host functioning as a client to a database that’s accessible via its native ODBC Driver.
Step 1: Download the Installer Archive
- Visit the OpenLink ODBC Enterprise Edition Driver Download Page to download the appropriate ODBC to ODBC Bridge Driver.
- Alternatively,
curlcan be used to download the installer archives andinstall.shscript directly:
curl -O https://download3.openlinksw.com/uda/components/9.0/x86_64-generic-win-64/waaozzzz.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
- You must possess third-party or native ODBC drivers that connect to your target data source. A client portion of these drivers must be installed on the same machine as the Multi-Tier “Enterprise” Edition Request Broker and Bridge Agent(s) for ODBC Data Sources.
- You must know whether the local ODBC components are 32-bit or 64-bit. The Multi-Tier server components must match the bit format of the local ODBC components, not the OS.
- A system ODBC DSN must be created for the third-party or native ODBC driver.
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 waaozzzz.msi, wabrzzzz.msi, wao3zzzz.msi MSI files.
- Run each MSI installer to install the client and server components of the Enterprise Multi-Tier ODBC-ODBC 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.
- Place the License file(s) (
oplrqb.lic, odbc.lic) either purchased or obtain during the evaluation download process in the{OPENLINK_INSTALL}/bindirectory.
Step 5: Create Data Source Name (DSN)
- Open the ODBC Data Source Administrator program.
- Click on the
Addbutton and select theOpenLink Generic ODBC Driver (Unicode)(9.0)driver.
- Enter the
{ODBC DSN Name}and{Hostname}:{Port Number}, default islocalhost:5000if making a localhost connection.
- Select the Domain
Odbc, set the Database to the Third party{ODBC DSN Name}, Login ID{Username}, Password, Select theConnect now to verify that all settings are correct and click theNextbutton to verify connection to the target database.
- These options can normally be left as the defaults.
- Details of the ODBC DSN are provided to for which the
Test Data Sourcebutton can be selected to test the connection.
- The connection should complete successfully
Step 6: Test connection
- Got to the
OpenLink Softwareprogram menu item and select theC++ Demosample application.
- Select the
Environment -> Open Connectionmenu item.
- Select the ODBC DSN for connection.
- Enter the username and password for the target database.
- Select the
SQL -> Execute SQLmenu item, enter the SQL query to be executed and click theOKbutton to execute.
- Query results are displayed.













