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)
Access 2010	Official (opens new window)	LibMDBODBC (opens new window)	LibMDBODBC (opens new window)
Access 2016	Official (opens new window)	LibMDBODBC (opens new window)	LibMDBODBC (opens new window)
SQLite (x86-64)	Server1 (opens new window) Server2 (opens new window) Official (opens new window)	SQLite ODBC (opens new window)	SQLite ODBC (opens new window)
MySQL (x86-64)	Server1 (opens new window) Server2 (opens new window) Official (opens new window)	Official (opens new window)	Official (opens new window)
MariaDB (x86-64)	Server1 (opens new window) Server2 (opens new window) Official (opens new window)	Official (opens new window)	Official (opens new window)
PostgreSQL (x86-64)	Server1 (opens new window) Server2 (opens new window) Official (opens new window)	Official (opens new window)	Official (opens new window)
SQL Server	Official (opens new window)	Official (opens new window)	Official (opens new window)
Oracle	Official (opens new window)

UnixODBC drivers (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)

(adsbygoogle = window.adsbygoogle || []).push({});

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>

2. 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

3. 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

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

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

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

(adsbygoogle = window.adsbygoogle || []).push({});