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

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.

Enterprise Architecture

Step 1: Download the Installer Archive

  1. Visit the OpenLink ODBC Enterprise Edition Driver Download Page to download the appropriate ODBC to ODBC Bridge Driver.
  2. 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/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

  1. Log onto the target machine for the installation
  2. Copy or downloaded all windows MSI installers to the target machine, which are the waaozzzz.msi, wabrzzzz.msi, wao3zzzz.msi MSI files.
  3. Run each MSI installer to install the client and server components of the Enterprise Multi-Tier ODBC-ODBC Bridge.
  4. Take care to enter correct information when prompted pertaining to ports, passwords, etc and ensure that you note these down for future use.
  5. The installation should finish without error.
Step 4: Configuration
  1. The installers would have setup all the environment variables etc required to use the OpenLink drivers.
  2. Place the License file(s) (oplrqb.lic, odbc.lic) either purchased or obtain during the evaluation download process in the {OPENLINK_INSTALL}/bin directory.

Step 5: Create Data Source Name (DSN)

  1. Open the ODBC Data Source Administrator program.

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

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

  1. Select the Domain Odbc , set the Database to the Third party {ODBC DSN Name}, 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.

  1. These options can normally be left as the defaults.

  1. Details of the ODBC DSN are provided to for which the Test Data Source button can be selected to test the connection.

  1. The connection should complete successfully

Step 6: Test connection

  1. Got to the OpenLink Software program menu item and select the C++ Demo sample application.

  1. Select the Environment -> Open Connection menu item.

  1. Select the ODBC DSN for connection.

  1. Enter the username and password for the target database.

  1. Select the SQL -> Execute SQL menu item, enter the SQL query to be executed and click the OK button to execute.

  1. Query results are displayed.

Additional Information