Solved

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

Posted on 2013-11-05
1
609 Views
Last Modified: 2013-11-12
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
0
Comment
Question by:HelpDeskGeiger
1 Comment
 
LVL 45

Accepted Solution

by:
Kdo earned 500 total points
ID: 39624371
Hi HelpDesk,

You need to match the driver to the host, not the server.  Install the 64-bit client on a 64-bit desktop.

The issue is that the tools have to interact with the 64 bit environment.  Variables, parameters, addresses, etc. are different in the 32 and 64 bit environments so they're not compatible.



Kent
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now