Please Login or Register
Advanced search

090 - How to setup odbc for AS400 in Ubuntu Linux

Submitted by admin on Mon, 06/01/2009 - 13:34

This is how to install iSeries odbc driver in your ubuntu machine.
First of all you need to download iSeries Access Linux from IBM site. Just for your notice you have to registrate yourself
before you can download anything from IBM site, this is not a big deal, cause it is so simple.

The file that you will get is an rpm file you will need alien to enabling you execute that file in your Ubuntu machine.
If you don't have alien in your Ubuntu then install it using.

# sudo apt-get alien

1. Install the iSeries Access and some packages that it needs.

# sudo alien -i iSeriesAccess-5.4.0-1.4.i386.rpm
# sudo apt-get install libmotif3
# sudo apt-get install libstdc++5

2. After you execute abobe steps, then here some configuration that you must do.

# sudo ln -s /opt/ibm/iSeriesAccess/lib/libcwbcore.so /usr/lib/ libcwbcore.so
# sudo ln -s /opt/ibm/iSeriesAccess/lib/libcwbodbc.so /usr/lib/libcwbodbc.so
# sudo ln -s /opt/ibm/iSeriesAccess/lib/libcwbodbcs.so /usr/lib/libcwbodbcs.so
# sudo ln -s /opt/ibm/iSeriesAccess/lib/libcwbrc.so /usr/lib/libcwbrc.so

3. Create odbc.ini in /etc

[AS400Master]
Description     = iSeries Access ODBC Driver
Driver          = iSeries Access ODBC Driver
System          = 192.168.xx.xx
UserID          = XUSER
Password        = XUSER
Naming          = 1
DefaultLibraries        = XSYS XGPL XDATABASE
Database                =
ConnectionType          = 2
CommitMode              = 2
ExtendedDynamic         = 1
DefaultPkgLibrary       = XDATABASE
DefaultPackage          = A/DEFAULT(IBM),2,0,1,0,512
AllowDataCompression    = 1
LibraryView             = 0
AllowUnsupportedChar    = 1
ForceTranslation        = 1
Trace           = 0