Configuring ODBC to update the shared library on Linux Platform

Details

Detail name Value
Changelog Number 20254
Type Improvement
Status Resolved
Fix Versions ODBC 24.0.0
Resolution Date 2024-03-11

Background

With the introduction of a new packaging mechanism for Linux 64-bit, Linux 32-bit, and Linux ppc64le, only the Exasol ODBC library (libexaodbc.so) supporting the unixODBC driver manager (libodbcinst.so) is included in the package. However, in cases where clients require the usage of other shared libraries such as Datadirect or any other shared library levels (libodbcinst.so, libodbcinst.so.1, and libodbcinst.so.2), the config_odbc utility should be utilized to configure the libexaodbc.so package accordingly.

Steps

  1. Access the terminal.
  2. Navigate to the directory containing the config_odbc utility.
  3. Execute the following command to update the shared library:
./config_odbc --mode=update_shared_lib --old_odbc_lib_index=<Existing Shared Library Index> --new_odbc_lib_index=<New Shared Library Index> --library=<Path to Exasol ODBC Library>

Shared Library Index Options

  1. libodbcinst.so
  2. libodbcinst.so.1
  3. libodbcinst.so.2

Example

To change from libodbcinst.so to libodbcinst.so.2, execute the following command:

$> ./config_odbc --mode=update_shared_lib --old_odbc_lib_index=1 --new_odbc_lib_index=3 --library=lib/libexaodbc.so
config_odbc 24.x.x (rev. exasol/drivers+master:xxxxxxxxxxxxxxxxxxxxxxxxxxx)
Copyright (c) 2024 EXASOL AG

  Library Name: lib/libexaodbc.so
  	Shared Library Name that needs to be updated: libodbcinst.so (Index: 1)
  	Selected ODBC Shared Library: libodbcinst.so.2 (Index: 3)
  EXAODBC - ODBC shared library is updated.

Additional Notes

  • Ensure proper permissions and access rights are granted for executing the config_odbc utility and accessing the relevant directories.

Improvement

The shared library configuration for ODBC should be successfully updated as per the specified indexes and library path.

  • For complete list of config_odbc options please call it with --help parameter.