Instalando o driver ODBC no CentoOS 7.

# yum install unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel

Por padrão o CentOs irá instalar o driver para conexão com o banco 

de dados PostgreeSQL via ODBC. Para instlar o s drivers para o MySQL,

execute o seguinte comando:
 

# yum install mysql-connector-odbc
 

Configurando ODBC para MySQL:

# nano /etc/odbcinst.ini

Insira o seguinte texto:

[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc3.so
Setup = /usr/lib/libodbcmyS.so
FileUsage = 1

 

Instlando o driver ODBC no Ubuntu 16:

# apt-get install libmyodbc


 Reading package lists... Done

 Building dependency tree

 Reading state information... Done

 Package libmyodbc is not available, but is referred to by another

package.

This may mean that the package is missing, has been obsoleted, or 

is only available from another source

E: Package 'libmyodbc' has no installation candidate

1- Faça o download do driver ODBC para ubuntu 16.10, no link 

https://dev.mysql.com/downloads/connector/odbc/

2- Extraia os arquivos:
#tar -xvf mysql-connector-odbc-5.3.7-linux-ubuntu16.10-x86-64bit.tar.gz

3- Copie o driver ODBC para a pasta:
#cp mysql-connector-odbc-5.3.7-linux-ubuntu16.10-x86-64bit/lib/libmyodbc5* /usr/lib/x86_64-linux-gnu/odbc/

4- Instale o driver: 
#mysql-connector-odbc-5.3.7-linux-ubuntu16.10-x86-64bit/bin/myodbc-installer -d -a -n "MySQL" -t "DRIVER=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5w.so;"

5- Checando a função:
mysql-connector-odbc-5.3.7-linux-ubuntu16.10-x86-64bit/bin/myodbc-installer -s -a -c2 -n "test" -t "DRIVER=MySQL;SERVER=127.0.0.1;DATABASE=mysql;UID=root;PWD=123456"

Resultado:

# isql test
+—————————————+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+—————————————+
SQL> show tables
+——————————————————————+
| Tables_in_mysql |
+——————————————————————+
| columns_priv |
| db |
| engine_cost |
| event |
| func |
……….
+——————————————————————+

Finalizando a configuração e verificando a conexão:
#cat /etc/odbc.ini
[test]
Driver=MySQL
SERVER=127.0.0.1
UID=root
PWD=123456
DATABASE=mysql
PORT=3306

radik@radik-VirtualBox:~$ cat /etc/odbcinst.ini
[MySQL]
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5w.so
UsageCount=1