TLBB Install iODBC & odbclib Unknown rwxr-xr-x 7:50:00 PM

Title	TLBB Install iODBC & odbclib
Permission	rw-r--r--
Author	Unknown
Date and Time	7:50:00 PM
Category
Share

Install Command:

• Ubuntu
• sudo apt-get install iodbc
• sudo apt-get install unixODBC:i386 unixODBC-dev:i386
• sudo apt-get install unixODBC unixODBC-dev
• apt-get install libmyodbc:i386
• apt-get install libmyodbc
• Centos
• yum install unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel
• yum install mysql-connector-odbc

Refer : http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/IODBCRubyHOWTO#Linux

I ended up installing just libmyodbc and configuring odbc using the /etc/odbc.ini file:

Ubuntu:

[ODBC Data Sources]

odbcname = MyODBC 3.51 Driver DSN

[tlbbdb]

Driver = /usr/lib/odbc/libmyodbc.so

Description = MyODBC 3.51 Driver DSN

SERVER = 127.0.0.1

PORT = 3306

USER = root

Password = 123456

Database = tlbbdb

OPTION = 3

SOCKET =

[Default]
Driver = /usr/local/lib/libmyodbc3.so
Description = MyODBC 3.51 Driver DSN
SERVER = localhost
PORT =
USER = root
Password = 123456
Database = test
OPTION = 3
SOCKET =

On Ubuntu Trusty 14.04 LTS (32-bit), replace the Driver value above with:

• /usr/lib/i386-linux-gnu/odbc/libmyodbc.so

Centos

[tlbbdb]

Description = ServerTLBB Database

Driver = /usr/lib/libmyodbc5.so

Server = 127.0.0.1

Database = tlbbdb

Port = 3306

Option = 3

User = root

Password = 123456

Socket = /var/lib/mysql/mysql.sock

libodbc.so.1 of ubuntu (Linux) x64 must be set in /usr/lib/ -> You must be symlink the libodbc.so in the tlbb Server to the lib, then symlink the /usr/lib/i386-linux-gnu/libltdl.so.3