Error:
: relocation error: /usr/lib64/libmyodbc5.so: symbol strove version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference
Cause:
this is an issue of back dated odbc-connector. You can check by systems' isql command that it's also returning same error. It's happen when there is a mismatch between the version of,
mysql-connector-odbc-5.1.5r114 4-7.el6.x86_64.rpm
&
MySQL-shared-compat-advanced-5 .6.22-1.el6.x86_64
Solution:
Download and install mysql-connector-odbc-5.3.4-1. el6.x86_64.rpm by,
rpm -Uvh mysql-connector-odbc-5.3.4-1. el6.x86_64.rpm
And after that change the following file,
$ vi /etc/odbcinst.ini
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib64/libmyodbc5w.so
Setup = /usr/lib64/libodbcmyS.so
Driver64 = /usr/lib64/libmyodbc5w.so
Setup64 = /usr/lib64/libodbcmyS.so
FileUsage = 1
[MySQL ODBC 5.3 Unicode Driver]
Driver = /usr/lib64/libmyodbc5w.so
UsageCount = 1
[MySQL ODBC 5.3 ANSI Driver]
Driver = /usr/lib64/libmyodbc5a.so
UsageCount = 1