Re: connect to DB2 from Ubuntu server with i Access Client Solutions

[Clay B Carley <cbc@xxxxxxxxx>]

Hi,

I have done this in CentOS, and as I recall it was fairly simple.  The 
.so file should be the driver file provided by IBM.  I have several .so 
files listed:

[root@carleynet etc]# locate .so | grep Access
/opt/ibm/iSeriesAccess/lib/libcwbcore.so
/opt/ibm/iSeriesAccess/lib/libcwbodbc.so
/opt/ibm/iSeriesAccess/lib/libcwbodbcs.so
/opt/ibm/iSeriesAccess/lib/libcwbrc.so
/opt/ibm/iSeriesAccess/lib/libcwbxda.so

If you have those files, I would imagine that the iSeries Access was 
installed correctly on your Debian system.  In addition, you need odbc.ini:

[root@carleynet etc]# cat odbc.ini
[Name for connection]
Description             = iSeries Access ODBC Driver
Driver          = iSeries Access ODBC Driver
System          = <System IP address>
UserID          = <User ID for access>
Password                = <Password for that user>
Naming          = 0
DefaultLibraries                = QGPL
Database                =
ConnectionType          = 0
CommitMode              = 2
ExtendedDynamic         = 1
DefaultPkgLibrary               = QGPL
DefaultPackage          = A/Default(IBM),2,0,1,0,512
AllowDataCompression            = 1
MaxFieldLength          = 32
BlockFetch              = 1
BlockSizeKB             = 128
ExtendedColInfo         = 0
LibraryView             = 0
AllowUnsupportedChar            = 0
ForceTranslation                = 0
Trace           = 0
DSN             = <Name for connection>

It's been a while, but looking through my history doesn't show that much 
more was needed.  CentOS is different than Debian, so file locations may 
be slightly different.  The version of iSeries access I am using is 
5.4.0-1.6.  Once everything was installed, and the odbc.ini file was 
configured correctly, I had no issues connecting to my system.

Good luck,
Clay




On 3/12/2015 10:20 AM, gMagQcy wrote:
> I am wanting to configure a linux ODBC connection to my i.
>
> I have Ubuntu server running as a VM on my PC.
> I have installed the iAccess Client Solutions per this:
> ftp://ftp.software.ibm.com/as400/products/clientaccess/solutions/QuickStartGuide_en.html
>
>
>
> now when I go to read about how to configure my ODBC, it
> is asking for a file with an extension of .so, but I can't find
> any....
>
> has anybody done this?