UnixODBC (FireDAC)

Go Up to Multi-Device Development (FireDAC)

General

FireDAC OS X uses UnixODBC to access:

• IBM DB2
• Informix
• SQL Server
• SQL Anywhere
• Teradata
• Other ODBC-based data sources.

FireDAC uses libodbc.so or the .dylib shared library to get access to ODBC API. Normally, it is located in the /usr/local/lib folder.

Installation

Often, the UnixODBC installed with OS may be:

• outdated
• not configured properly
• or not installed, as on OS X.

So, if UnixODBC is installed, we recommend to reinstall it, although it is optional step.

You should decide which UnixODBC version to use and how to install it:

• On OS X:
  • Use UnixODBC v 2.3.0 if you are not experienced with OS X.
  • Use the latest UnixODBC v 2.3.4 if you are experienced with OS X.

Install on OS X

To install UnixODBC on OS X, use the following commands:

export CFLAGS=-m32
wget ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.4.tar.gz
tar -zxvf unixODBC-2.3.4.tar.gz
cd unixODBC-2.3.4
./configure --enable-gui=no --enable-drivers=no --enable-stats=no --enable-iconv --with-iconv-char-enc=UTF8 --with-iconv-ucode-enc=UTF16LE
make
sudo make install
cd ..