IBM i Access ODBC Installation¶
The instructions for installing and ODBC driver and manager and the IBM i ODBC driver for Db2 on i will depend on what operating system you are running. Select your operating system below to see setup instructions for getting ODBC on your system and connected to IBM i.
IBM i¶
The ODBC driver for IBM i is provided in the ibm-iaccess
package, so it can be
easily installed with yum
. For instance:
yum install ibm-iaccess
Installing this RPM will do the following:
Install the IBM i Access ODBC driver
Install the
unixODBC
driver managerRegister the driver with the driver manager by putting the appropriate information in the
odbcinst.ini
file (see using).Create a datasource name (DSN) for your local system called
*LOCAL
. This is discussed further in the “using” doc.
Linux¶
IBM now has RPM and DEB repositories for Linux available directly from IBM for the IBM i Access Client Solutions application package, which includes the IBM i Access ODBC driver.
On Linux, we will be using unixODBC as our driver manager. Fortunately, unixODBC
is automatically pulled in when you install the IBM i Access ODBC Driver for
Linux, so there isn’t any set up that you have to do for this stage. If you want
to develop applications using ODBC packages like pyODBC for Python or odbc for
Node.js, you will have to manually use yum to install unixODBC-devel
as well.
Installing the Repository¶
The repositories are located under https://public.dhe.ibm.com/software/ibmi/products/odbc/.
Red Hat-based Distribution Setup¶
curl https://public.dhe.ibm.com/software/ibmi/products/odbc/rpms/ibmi-acs.repo | sudo tee /etc/yum.repos.d/ibmi-acs.repo
SUSE-based Distribution Setup¶
curl https://public.dhe.ibm.com/software/ibmi/products/odbc/rpms/ibmi-acs.repo | sudo tee /etc/zypp/repos.d/ibmi-acs.repo
Debian-based and Ubuntu-based Distribution Setup¶
curl https://public.dhe.ibm.com/software/ibmi/products/odbc/debs/dists/1.1.0/ibmi-acs-1.1.0.list | sudo tee /etc/apt/sources.list.d/ibmi-acs-1.1.0.list
Windows¶
Driver Manager for Windows¶
Windows comes preinstalled with an ODBC driver manager. To access it, search for
Administrative Tools
on your system (either through the search bar, or
Control Panel > System and Security > AdministrativeTools
), and then from
there select ODBC Data Sources (either 32-bit or 64-bit).
From this application, you can set up your drivers.
Driver for Windows¶
You will have to install the ODBC driver that allows Windows ODBC driver manager to talk to Db2 on i. To get the driver, visit the IBM i Access Client Solutions page and select Downloads for IBM i Access Client Solutions. After logging in and redirected to the IBM I Access Client Solutions download page, scroll down and download the ACS Windows App Pkg English (64bit).
When the package has been downloaded and has been installed on your system, it should be available to see on your ODBC Data Source Administrator application.
macOS¶
Driver Manager for macOS¶
On macOS, you will need unixODBC as your ODBC driver manager. Many macOS ODBC
programs use another driver manager called iodbc, but the IBM i ODBC driver
will not work with iodbc. unixODBC is available on homebrew
, and can be
installed running the following command:
brew install unixodbc
Driver for macOS¶
You will also have to install the macOS ODBC driver that allows unixODBC to talk
to Db2 on i. To get the driver, visit the IBM i Access Client Solutions page
and select Downloads for IBM i Access Client Solutions. After logging in and
redirected to the IBM I Access Client Solutions download page, scroll down and
download the ACS Mac App Pkg. The package will include a standard macOS
installer package, which can be installed by double clicking orby running the
pkgutil
command.