Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2013-11-05
1
Medium Priority
?
644 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 46

Accepted Solution

by:
Kent Olsen earned 1500 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
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…
Integration Management Part 2
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…

578 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