Installing OpenEdge SQL Client Access ODBC drivers on Ubuntu 16.04

Progress OpenEdge SQL ODBC drivers

You can obtain and install OpenEdge SQL Client Access drivers ODBC drivers (aka SQL ODBC drivers) from Progress’s Electronic Software Delivery (ESD) website. Contact Progress support or your account manager for details. SQL ODBC drivers for OpenEdge are available for Windows and Linux. This article focuses on installing SQL driver on Ubuntu 16.04 GNU/Linux Server and is a continuation of Modern web applications and API with OpenEdge, SQL, ODBC and PHP

Install ODBC drives

Pre-requisites

Install the following software prior to installing SQL ODBC drivers

  • unixodbc – to support ODBC access to OpenEdge
  • unixodbc-dev
  • xterm – to support character based installer (ncurses/curses)
  • php 7.1 and php 7.1 odbc – to test connectivity
  • OpenEdge SQL Drivers (e.g. PROGRESS_OE_11.7_LNX_64_SQLCLIENTACCESS.tar.gz)

Installing pre-requisites

Let’s install all the necessary pre-requisites before installing Progress OpenEdge SQL drivers for ODBC.

Begin Installation of OpenEdge SQL ODBC drivers

We will create a directory called test and unzip contents of SQL Client Access zip file in it.

At this point, you need to have your serial number and control number ready. You can obtain them from Progress’s ESD website or by asking your account manager.

Enter serial number and control number

After entering the numbers, hit Enter. If the numbers appear correct, you will see a message that control number has been confirmed and accepted.

Hit CTRL-E to go to the next screen and Hit Y when you see a screen like this:

You will notice that Continue with Installation will be highlighted by default. Hit Enter on the screen below to install the drivers.

Choosing default location for installation

Acknowledge the final step by hitting Y

Use the default location to install scripts

After installation, End the OpenEdge installation will be highlighted by default. Hit Enter.

You have now installed OpenEdge SQL drivers for ODBC. Congratulations!

Confirm correctness of OpenEdge ODBC drivers

Let’s confirm that our drivers have been installed correctly.

Notice that libpgicu27.so was not found. Let’s copy this file to the right destination.

After libpgicu27.so was copied to /usr/lib, we are noticing that all shared object dependencies for pgoe27.so are met. Excellent!

Set up ODBCINST

Edit /etc/odbcinst.ini and enter the following information:

This file makes our drivers available for working with OpenEdge.

Testing OpenEdge ODBC connection

Assumption is made that your OpenEdge installation is serving ODBC connectivity already. My OpenEdge database is based on sports2000 and SQL engine is listening on port 10000.

Test.php

Results

Results were returned in less than 15 ms and the experience was outstanding. This code can be translated into a quick API prototype, don’t you think?

Ports to open for OpenEdge SQL Access

I have OpenEdge SQL serving from port 10000. My OpenEdge instance is running on one virtual machine. In order for me to access OpenEdge from another virtual machine, port 10000 should be unblocked. Additionally, port 1025-2000 on Linux and port 3000-5000 on Windows should also be open for clients to access OpenEdge database using SQL. See knowledgebase article from Progress about opening ports also.

This concludes our goal of installing OpenEdge SQL Client Access ODBC drivers on Ubuntu. Hope you can follow these methods to test with your own favorite modern language.

See more articles on Modern web applications and API with OpenEdge, SQL, ODBC and PHP