[MySql] relocation error: /usr/lib64/libmyodbc5.so: symbol strmov, version libmysqlclient_16 not defined

When using myDSN and connection to remote DB(MySQL) this issue arise.

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.5r1144-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,

wget http://ftp.kaist.ac.kr/mysql/Downloads/Connector-ODBC/5.3/mysql-connector-odbc-5.3.4-1.el6.x86_64.rpm

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