Link to home
Start Free TrialLog in
Avatar of HelpDeskGeiger
HelpDeskGeigerFlag for United States of America

asked on

Installing 32-bit iSeriesAccess for linux on 64-bit machine.

I’m attempting to install the 32-bit version of iSeriesAccess for linux on a 64-bit Ubuntu 12.04 box. We were having some issues with the 64bit version and have confirmed everything works on the 32bit version with a 32bit box. I have gone through the installer the same way that I did on a 32bit machine however I’m getting the following error message when trying to connect with isql:

$ isql -v GBAS400
[01000][unixODBC][Driver Manager]Can't open lib '/opt/ibm/iSeriesAccess/lib/libcwbodbc.so' : file not found
[ISQL]ERROR: Could not SQLConnect

the file /opt/ibm/iSeriesAccess/lib/libcwbodbc.so does exist.

unixodbc setup:
unixODBC 2.2.14
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /home/vagrant/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

odbc.ini file:
[GBAS400]
Description = iSeries Access ODBC Driver DSN for iSeries
Driver = iSeries Access ODBC Driver
System = 10.10.2.20
Naming = 0
DefaultLibraries = GB1555AFGD
ConnectionType = 0
CommitMode = 2
ExtendedDynamic = 0
DefaultPkgLibrary = GB1555AFGD
DefaultPackage = A/DEFAULT(IBM),2,0,1,0,512
AllowDataCompression = 1
LibraryView = 0
AllowUnsupportedChar = 0
ForceTranslation = 0
Trace = 0
CCSID = 1208

odbcinst.ini file:
[iSeries Access ODBC Driver]
Description             = iSeries Access for Linux ODBC Driver
Driver          = /opt/ibm/iSeriesAccess/lib/libcwbodbc.so
Setup           = /opt/ibm/iSeriesAccess/lib/libcwbodbcs.so
Threading               = 2
DontDLClose             = 1
UsageCount              = 1
ASKER CERTIFIED SOLUTION
Avatar of Kent Olsen
Kent Olsen
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial