Jump to Navigation

073 - How to setup odbc for AS400 in Fedora Linux

You have to download the following package from IBM and install it.

[MyServer]# rpm -ihv iSeriesAccess-5.4.0-1.4.i386.rpm

Maybe you get the errors.

 error: Failed dependencies:
        libstdc++.so.5 is needed by iSeriesAccess-5.4.0-1.4.i386
        libstdc++.so.5(CXXABI_1.2) is needed by iSeriesAccess-5.4.0-1.4.i386
        libstdc++.so.5(GLIBCPP_3.2) is needed by iSeriesAccess-5.4.0-1.4.i386
        libstdc++.so.5(GLIBCPP_3.2.2) is needed by iSeriesAccess-5.4.0-1.4.i386
        libXm.so.3 is needed by iSeriesAccess-5.4.0-1.4.i386
        libXp.so.6 is needed by iSeriesAccess-5.4.0-1.4.i386

[MyServer]# yum provides libstdc++.so.5

Loaded plugins: refresh-packagekit
compat-libstdc++-33-3.2.3-64.i386 : Compatibility standard C++ libraries
Repo        : fedora
Matched from:
Other       : libstdc++.so.5

yum install compat-libstdc++-33
yum install libXp

Unless you use openmotif, you can install the package with nodeps option.

[MyServer]# rpm -ivh --nodeps iSeriesAccess-5.4.0-1.2.i386.rpm

Change your odbc.ini in /etc.

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

Test to connect to DB in AS400.

# isql -v [myDSN] username password

 



Main menu 2

Story | by Dr. Radut