× 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.



Once you get yum working go ahead and install the unixODBC, wget and rpm components before installing the i access PASE ODBC driver.

-After that I just downloaded the zip file and unzipped the RPM file into the root folder of the IFS

-Then run go into the PASE shell with: CALL QP2TERM

Run following commands from PASE shell:

cd /
PATH=/QOpenSys/pkgs/bin
export PATH
rpm -i ibm-iaccess-1.1.0.11-0.ibmi7.2.ppc64.rpm

Then you can exit QP2TERM

That's what did it for me.

After installation your ODBC config file is located here: /QOpenSys/etc//odbc.ini

Before editing odbc.ini, do a WRKRDBDIRE to find your *LOCAL database name. Mine is SYS1

[*LOCAL]
Description = local
Driver = IBM i Access ODBC Driver
System = localhost
Naming = 0
Database = SYS1

You localhost DSN name is now *LOCAL. You can create other named entries if you want. I have not tried connecting to a remote IBMi, but that may work as well.

Now you want to test your ODBC connectivity. Go back into PASE shell: CALL QP2TERM

Run the following commands from the PASE shell to start the isql ODBC test utility

PATH=/QOpenSys/pkgs/bin
export PATH
isql '*LOCAL' user1 pass1 (Use your own IBMi user/password)

If connect succeeds it looks something like this:
+---------------------------------------+
|Connected!
| sql-statement
| help[tablename]
| quit
+---------------------------------------+

Then run a query. Type: select * from qiws.qcustcdt and press <enter>

You should see your results on screen in the isql session.

All done !!

For any apps that need ODBC, simply use the following connection string for ODBC:

DSN=*LOCAL;UID=user1;PWD=pass1

Note: I don't think there is an option to use the driver without a user/password. I can be proven wrong though 😊

Have fun

Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
Phn: (612) 315-1745

------------------------------

message: 2
date: Thu, 20 Jun 2019 14:33:36 +0000
from: "Andrew Lopez (SXS US)" <Andrew.Lopez@xxxxxxxxxxxxxxxxxx>
subject: Re: [EXT] new ODBC driver

Maybe I should write Part2 on installation?.

That would be quite welcome! The RPM stuff is quite new for a lot of folks.

Yes, please. Having an ODBC driver on the IFS would resolve some issues with a sister company not wanting to install drivers (unapproved software) on their own systems. I went to start this and got sidetracked by YUM not really being installed on our system. I went to install YUM, and found that SSHD is not started by default. I started it, but SSHD is apparently refusing to run and not leaving me any logs as to why it didn't start. At this rate, I'll be sorting out something completely unrelated to the task at hand.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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.