# ODBC drivers

# Third-party ODBC drivers(free)

List some ODBC drivers and it's download link

ODBC Components Windows Linux macOS
ODBC Driver Manager Built-in UnixODBC (opens new window) / iODBC (opens new window) UnixODBC (opens new window) / iODBC (opens new window)
SQLite x86-64 (opens new window)
MySQL x86-64 (opens new window)
MariaDB x86-64 (opens new window)
PostgreSQL x86-64 (opens new window)
SQL Server x86-64 (opens new window) x86-64 (opens new window) x86-64 (opens new window)
Oracle x86-64 (opens new window)

# Third-party ODBC drivers(charged)

Easysoft ODBC Drivers (opens new window)
CData Software ODBC Drivers (opens new window)
Devart ODBC Drivers (opens new window)

# UnixODBC / iODBC install and setup

  1. Install UnixODBC / iODBC
yum install -y <unixodbc | iodbc>
yum install mysql-connector-odbc mariadb-connector-odbc pgodbc <ODBC driver package>
  1. Setup ODBC drivers
    default path: /etc/odbcinst.ini, the ODBC driver template as follow:
[DRIVER_NAME]
  Description = description of the ODBC driver
  Driver = path_to_odbc_driver_shared_object
  Setup = path_to_driver_setup_shared_object

after that, You can list all installed ODBC drivers with: odbcinst -q -d

  1. Setup system data sources
    default path: /etc/odbc.ini, the data source template as follow
[my_datasource]
Driver = OOB
Description = description_of_data_source
ServerPort = myoobserver:8888
TargetDSN = mytargetdsn
LogonUser = server_username
LogonAuth = password_for_LogonUser

The most important is that the driver name in datasource should be same as the driver name in the file: odbcinst.ini

  1. Setup file data sources
    default path: /etc/ODBCDataSources, the syntax same as

  2. Setup user data sources
    default path: /home/auser/.odbc.ini

finaly, You can list user and system data sources with: odbcinst -q -s