× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. February 2018

Re: iACS Linux ODBC Instalation

I don't have access to the ODBC-GUI. Here is what I plan on using.



I will create a directory called /opt/ibm

Upload the RPM file to it.

Run these commands:

rpm -ivh ibm-iaccess-1.1.0.7-1.0.x86_64.rpm

rpm -Uvh ibm-iaccess-1.1.0.7-1.0.x86_64.rpm

The driver will end up in:
/opt/ibm/iSeriesAccess/lib64/libcwbodbc.so

At this point I should be able to configure my driver.




On Thu, Feb 1, 2018 at 5:22 PM, Don Brown <DBrown@xxxxxxxxxx> wrote:

We were using Linux (Ubuntu 16.04)?

After downloading the latest iACS Linux Drivers this just worked - well I
supplied the drivers to the Linux dude and he said great - all working.

The iACS ODBC driver download is a separate download - not included in the
base iACS download

I have these notes from obtaining the download ...

The sequence is: Go into ESS then after clicking on the Software Downloads
option...
Select IBM i operating system and press continue
Select the product 5770-SS1 and press continue at the bottom of the list
Press continue again
Click on the hide/show link
Click on the next hide/show link that appears under the first one you
clicked (it is titled something similar to 5837: i7.3 B_GROUP1
v07.03.00,ENU,DVD )
At the bottom of that expanded section you will see
IBM i Access Client Solutions - Linux AP
29


Select it and press continue and follow the prompts from there to download
it.
Then read the install instructions here:
http://www-03.ibm.com/systems/power/software/i/access/linux/guide.html


I also have the following installation notes but think these were provided
by someone on this list. Proberbly Kevin Bucknum

Installing the ODBC Driver on Linux and Configuring ...

This is old, but looks correct.

https://www.ibm.com/support/knowledgecenter/en/ssw_i5_54/
rzatv/rzatvodbc.htm


I think all I did was install odbc with sudo apt install libmyodbc
I have this entry in /etc/odbcinst.ini

[IBM i Access ODBC Driver 64-bit]
Description=IBM i Access for Linux 64-bit ODBC Driver
Driver=/opt/ibm/iaccess/lib64/libcwbodbc.so
Setup=/opt/ibm/iaccess/lib64/libcwbodbcs.so
Threading=0
DontDLClose=1
UsageCount=1

And this in /etc/odbc.ini

[iSeries]
Description = iSeries Access ODBC Driver DSN for iSeries
Driver = IBM i Access ODBC Driver 64-bit
System = 192.168.2.20
UserID = kevin
Password = notreallymypassword
Naming = 0
DefaultLibraries = MPMS04
Database = MPMS04
ConnectionType = 0
CommitMode = 2
ExtendedDynamic = 0
DefaultPkgLibrary = QGPL
DefaultPackage = A/DEFAULT(IBM),2,0,1,0,512
AllowDataCompression = 1
LibraryView = 0
AllowUnsupportedChar = 0
ForceTranslation = 0
Trace = 0




Don Brown

MSD Information Technology

Suite 5/29 McDougall Street Milton Q 4064
( 07 3368 7888
+ PO Box 1629 MILTON Q 4054
Ê 07 3368 7877
* Don.Brown@xxxxxxxxxx
È 0408 751 644
þ www.msd.net.au www.architect4web.com.au





I am a proud supporter of THE REFERRAL NETWORK and recommend the services
of the other member businesses. For more information please checkout the
website www.refnet.net.au





From: "Jack Kingsley" <iseriesflorida@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: 01/02/2018 08:03 PM
Subject: Re: iACS Linux ODBC Instalation
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Don, what version of LINUX are you trying to get this to work on. I found
this site that has some more detailed information as well. I am working
on
something like this currently, if you get it working let me know how it
goes. I will probably be using the 64bit rpm.

http://yips.idevcloud.com/wiki/index.php/Tier2/IAccess

On Fri, Oct 27, 2017 at 3:24 PM, Kevin Adler <kadler@xxxxxxxxxx> wrote:

When you unzip the IBMiAccess_v1r1_LinuxAP.zip it should have a
readme.txt
in it. There's installation instructions in there. We don't have any
instructions on how to set up a DSN, though. It looks like Kevin
Bucknam
already provided some DSN info. I'd say that you don't need to
specify
the
64-bit specific driver name, though it is unlikely anybody is running
32-bit Linux anymore.

For a list of keywords you can configure for the DSN, refer to this
knowledge center page:
[1]https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/rzaik/
connectkeywords.htm



----- Original message -----
From: Don Brown <DBrown@xxxxxxxxxx>
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxx>
Cc:
Subject: iACS Linux ODBC Instalation
Date: Wed, Oct 25, 2017 4:17 PM

Firstly let me state that Linux is by far not my strong suit.

I am trying to assist in setting up an ODBC connection from a
Ubuntu
16.04
to a IBMi at V7R3

I have downloaded the Linux optional extensions from IBM ESS Site.

But I can't find any documentation either in the downloaded package
or
Googling that says anything about ODBC

Would anyone have any links or doco that may assist ?

Appreciate any responses

Thank you and enjoy your day ... Errrrrr Night for most of you.

Don Brown

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
[2]https://urldefense.proofpoint.com/v2/url?u=https-
3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&
d=DwICAg&c=jf_iaSHvJObTbx-siA1ZOg&r=2aXRESXNvBGuLbIQEybCPNLc7OK0Uq
jwsZsoCq7Jz6o&m=3ipqJHspmUN33IybqOsmEHzcXiM7aFvRRwL-H5uX0kU&s=
RoOeYJBkkfNQT3JFKvldEKO6DGe15y-djq3yi9R5pok&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
[3]https://urldefense.proofpoint.com/v2/url?u=https-

3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=jf_iaSHvJObTbx-siA1ZOg&r=
2aXRESXNvBGuLbIQEybCPNLc7OK0UqjwsZsoCq7Jz6o&m=
3ipqJHspmUN33IybqOsmEHzcXiM7aFvRRwL-H5uX0kU&s=
a13BreyESsXu7wzhHSGd8nfM7yd4EM7e14hI0HyBRCI&e=.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our
affiliate
link:
[4]https://urldefense.proofpoint.com/v2/url?u=http-
3A__amzn.to_2dEadiD&d=DwICAg&c=jf_iaSHvJObTbx-siA1ZOg&r=
2aXRESXNvBGuLbIQEybCPNLc7OK0UqjwsZsoCq7Jz6o&m=
3ipqJHspmUN33IybqOsmEHzcXiM7aFvRRwL-H5uX0kU&s=oEtav6fyIoOZkwtzO_
Pa3Lkbw3Re056pnj-CCZQrgTs&e=




References

Visible links
1. https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/
rzaik/connectkeywords.htm
2. https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.
midrange.com_mailman_listinfo_midrange-2Dl&d=DwICAg&c=jf_
iaSHvJObTbx-siA1ZOg&r=2aXRESXNvBGuLbIQEybCPNLc7OK0UqjwsZsoCq7Jz6o&m=
3ipqJHspmUN33IybqOsmEHzcXiM7aFvRRwL-H5uX0kU&s=
RoOeYJBkkfNQT3JFKvldEKO6DGe15y-djq3yi9R5pok&e=
3. https://urldefense.proofpoint.com/v2/url?u=https-3A__
archive.midrange.com_midrange-2Dl&d=DwICAg&c=jf_iaSHvJObTbx-siA1ZOg&r=
2aXRESXNvBGuLbIQEybCPNLc7OK0UqjwsZsoCq7Jz6o&m=
3ipqJHspmUN33IybqOsmEHzcXiM7aFvRRwL-H5uX0kU&s=
a13BreyESsXu7wzhHSGd8nfM7yd4EM7e14hI0HyBRCI&e=
4. https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_

2dEadiD&d=DwICAg&c=jf_iaSHvJObTbx-siA1ZOg&r=2aXRESXNvBGuLbIQEybCPNLc7OK0Uq
jwsZsoCq7Jz6o&m=3ipqJHspmUN33IybqOsmEHzcXiM7aFvRRwL-H5uX0kU&s=
oEtav6fyIoOZkwtzO_Pa3Lkbw3Re056pnj-CCZQrgTs&e=
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.