Why mysql odbc configuration not setup in linux?
<p>I have two systems. my first system is ubuntu 16.04. which, work as remote.
and another is centos 6. which, run in virtually. In centos, freeswitch installed. I have to send data from freeswitch to remote system means ubuntu.
on centos, my configuration of odbc.ini as :</p>

<pre><code>[freeswitch]
DRIVER = /usr/lib64/libodbcmyS.so
SERVER = &lt;ipaddress&gt;
USER = root
PASSWORD = &lt;password&gt;
PORT = 3306
DATABASE = freeswitch
OPTION = 67108864
</code></pre>

<p>and odbcinst.int as below:</p>

<pre><code>[MySQL]
Description     = ODBC for MySQL
Driver          = /usr/lib64/libmyodbc.so
Setup           = /usr/lib64/libodbcmyS.so
FileUsage       = 1
Threading = 0
</code></pre>

<p>after setup above code.
I have to check odbc connection. for this, command fire as :</p>

<pre><code>isql -v freeswitch
</code></pre>

<p>but, it show error as :</p>

<pre><code>[IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
[ISQL]ERROR: Could not SQLConnect
</code></pre>