Trouble viewing images? Click on images to enlarge.

 

This article will cover the installation and setup of the Universe ODBC Driver. Before getting started it is recommended to find out if you need to download the 32 bit or 64 bit ODBC Driver. This process will be divided into 4 main steps. If you would like to see a video of the process, at the bottom of the article the steps are in video form.

Note: Universe ODBC communicates via the UniRPC service which operates over TCP port 31438 by default.

 

Step 1: Download and install the ODBC Driver.

Step 2: Modify the UCI.config file with your server information.

Step 3: Create a new ODBC data source.

Step 4: Create a connection profile using the new setup.

 

Download either the 64-bit or 32-bit ODBC driver (varies depending on your system)

32-bit ODBC Driver - https://license.bridgeworksllc.com/downloads/U2ODBC_32bit.msi

64-bit ODBC Driver - https://license.bridgeworksllc.com/downloads/U2ODBC_64bit.msi

 

NOTE: Some systems require an older version of ODBC available here.

 

ODBC Setup Steps

Step 1: Download and install the ODBC Driver.

 

1. Run the MSI that was downloaded

 

 

2. Go through the installation process until it's complete.

 

 

Step 2: Modifying the UCI.config file with your information.

1. Browse to the UCI.config file. File Path: C:\U2\UniDK\Config

 

 

2. Open the UCI.config file with a text editor (Notepad, Wordpad, etc.)

 

 

3. Enter your server information in the areas indicated by the orange text. (Enter Your Server Info Here)

 

 

Example Server Setup:

 

 

4. Save the changes to the file.

 

 

Step 3: Create a new ODBC data source.

(Note: Default port for Universe ODBC is 31438)

 

1. Open ODBC Data Sources. (Search ODBC Data Source)

Note:
If you have 32 bit you need to use the 32 bit ODBC Data Source
If you have 64 bit you need to use the 64 bit ODBC Data Source

 

 

 

 

2. Click the System DSN tab

 

 

3. Click Add.

 

 

4. Select U2 64/32-bit ODBC Driver and click finish.

 

 

5. Enter your information

 

 

6. Test the connection then finish. 

 

 

Step 4: Create a connection profile using the new setup.

(Note: Default port for Universe ODBC is 31438)

1. Inside VDM, click on the Database tab.

 

 

2. Click New in the Connections section of the ribbon bar. 

 

 

3. Click the drop down on Connection Type and choose Select Platform, then click Next.

 

4. Click the drop down on DSN and select the new DSN

 

 

5. Enter the Server Name that was used in the ODBC setup.

 

 

6. Select your Platform.

 

 

7. Enter your Username and Password used in the ODBC setup.

 

 

8. Click Test Connection, if the connection passed. click Next.

 

 

9. Click Finish and save the new Connection Profile.

 

10. Click the Load All button to populate the new connection.

 

Video Steps

 

Step 1: Download and install the ODBC Driver.

 

 

Step 2: Modifying the UCI.config file with your information.

 

 

Step 3: Create a new ODBC data source.

 

 

Step 4: Create a connection profile using the new setup.