Re: iACS Linux ODBC Instalation

[Don Brown <DBrown@xxxxxxxxxx>]

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