mysql ODBC not working

[mflorezm]

Hi, i'm having problems to install and use MysQL ODBC connector in  ARMBIAN 5.60 stable Ubuntu 16.04.5 LTS 3.4.113-sun8i.  As you know for this version of ubuntu there is no Package 'libmyodbc' installation candidate.

 

So, I downloaded ODBC driver for Ubuntu 16.04 directly with wget https://dev.mysql.com/get/Downloads/Connector-ODBC/5.3/mysql-connector-odbc-5.3.11-linux-ubuntu16.04-x86-32bit.tar.gz (32bit as H3 is 32 bits - but same happens with 64 bits too)  

 

Copied all libraries (libmyodbc5a.so  libmyodbc5S.so  libmyodbc5w.so) to folder /usr/local/odbc/lib

 

then create the /etc/odbc.ini file with the following data:

 

[MySQL-asteriskcdrdb]
Description=MySQL connection to 'asteriskcdrdb' database
driver=MySQL
server=localhost
database=asteriskcdrdb
Port=3306
Socket=/var/run/mysqld/mysqld.sock
option=3
Charset=utf8

 

and create the /etc/odbcinst.ini
 

[MySQL]
Description=MySQL driver for Linux
Driver=/usr/local/odbc/lib/libmyodbc5w.so
Setup=/usr/local/odbc/lib/libmyodbc5S.so
FileUsage=1
 

nevertheless, while using isql i always receive the following error:

 

root@orangepiplus:/usr/local/odbc/lib# isql -vvv MySQL-asteriskcdrdb
[01000][unixODBC][Driver Manager]Can't open lib '/usr/local/odbc/lib/libmyodbc5w.so' : file not found
[ISQL]ERROR: Could not SQLConnect

 

of course it is not true, because the all the library files are there:

 

root@orangepiplus:/usr/local/odbc/lib# ls
libmyodbc5a.so  libmyodbc5S.so  libmyodbc5w.so

 

Any ideas? is it the kernel? is it the ARMHF arquitecture? because the same process works perfect on other linux machines i386.

 

Regards,

 

Mauricio F.

 

 

 

 

 

[martinayotte]

10 hours ago, mflorezm said:

So, I downloaded ODBC driver for Ubuntu 16.04 directly with wget https://dev.mysql.com/get/Downloads/Connector-ODBC/5.3/mysql-connector-odbc-5.3.11-linux-ubuntu16.04-x86-32bit.tar.gz (32bit as H3 is 32 bits - but same happens with 64 bits too)

You've downloaded a x86_32bits not an ARMHF ...