Installation / Setup of Universe ODBC Driver

Cory Fifield -

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.

 

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

 

 

ODBC Setup Steps

Step 1: Download and install the ODBC Driver.

 

1. Run the MSI that was downloaded

mceclip1.png

 

 

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

mceclip3.png

 

 

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

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

mceclip4.png

 

 

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

mceclip6.png

 

 

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

mceclip8.png

 

 

Example Server Setup:

mceclip9.png

 

 

4. Save the changes to the file.

mceclip10.png

 

 

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

 

mceclip11.png

 

 

 

2. Click the System DSN tab

mceclip12.png

 

 

3. Click Add.

mceclip13.png

 

 

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

mceclip14.png

 

 

5. Enter your information

mceclip15.png

 

 

6. Test the connection then finish. 

mceclip16.png

 

 

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.

mceclip1.png

 

 

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

mceclip2.png

 

 

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

mceclip0.png

 

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

mceclip3.png

 

 

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

mceclip4.png

 

 

6. Select your Platform.

mceclip5.png

 

 

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

mceclip6.png

 

 

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

mceclip7.png

 

 

9. Click Finish and save the new Connection Profile.

mceclip9.png

 

 

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.

Have more questions? Submit a request

Comments