UNIX platforms utilize a file called odbc.ini to configure ODBC settings for an installation. A sample version for OpenEdge is provided in the $DLC/odbc directory. For example:

[ODBC Data Sources]
sports=Progress_SQL92_Driver
[sports]
Driver=/usr/dlc/odbc/lib/pgoe28.so
DatabaseName=default
PortNumber=2055
HostName=localhost
LogonID=testuser
Password=xxx
APILevel=1
ConnectFunctions=YYN
CPTimeout=60
DriverODBCVer=03.52
FileUsage=0
SQLLevel=0
UsageCount=1
ArraySize=50
DefaultLongDataBuffLen=2048
DefaultIsolationLevel=REPEATABLE READ
StaticCursorLongColBuffLen=4096
[ODBC]
InstallDir=/usr/dlc/odbc
Trace=0
TraceFile=odbctrace.out
TraceDll=/usr/dlc/odbc/lib/odbctrac.so
UseCursorLib=0

The first section, [ODBC Data Sources], contains a list of data sources available for an ODBC client. In this case, the data source name (DSN) is sports.

The [sports] section contains data-source-specific information for the DSN sports. The odbc.ini file should contain a section like this for each DSN the client might wish to use. The name of the DatabaseName, PortNumber, and HostName should be replaced with the unique DataSource Name, the HostName serving the database, the PortNumber, and Database Name identified during the preparation steps. For example:

[sports]
Driver=/usr/dlc/odbc/lib/pgoe28.so
DatabaseName=mysports
PortNumber=2055
HostName=myhost
LogonID=testuser
Password=xxx
APILevel=1
ConnectFunctions=YYN
CPTimeout=60
DriverODBCVer=03.52
FileUsage=0
SQLLevel=0
UsageCount=1
ArraySize=50
DefaultLongDataBuffLen=2048
DefaultIsolationLevel=REPEATABLE READ
StaticCursorLongColBuffLen=4096
Note: With the upgrade of the Progress OpenEdge ODBC driver from version 07.16.0304 to 08.02.0293 in OpenEdge Release 12.8.7, the driver file name has changed from pgoe27.so to pgoe28.so. Therefore, you must update the Driver tag in the odbc.ini file to reflect the new path of the upgraded ODBC driver, typically found in the $DLC/odbc/lib directory within the OpenEdge installation path.