Configure data sources on a UNIX environment
- Last Updated: July 28, 2025
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
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], 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:
|
Note: With the upgrade of the Progress
OpenEdge ODBC driver from version
07.16.0304 to 08.02.0293
in OpenEdge Release 12.2.18, 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.