×
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.
John:
All the users are on the same LPAR. The Python code is contained within an RPG app, and all of the users are using the same app. Here are the packages I have installed:
-bash-4.3$ yum list installed | grep "ODBC\|ibm-iaccess"
ibm-iaccess.ppc64 1.1.0.12-0 @/ibm-iaccess-1.1.0.12-0.ibmi7.2.ppc64
unixODBC.ppc64 2.3.4-2 @ibm
unixODBC-devel.ppc64 2.3.4-2 @ibm
----------
Kevin Adler on Ryver suggested supplying a password, but end-users don't have passwords. We use Enterprise Identity Mapping (EIM) SSO which is a base component of IBMi. Devs & admins use EIM but still have a password due to not all interfaces supporting EIM.
-----Original Message-----
From: John Yeung [mailto:gallium.arsenide@xxxxxxxxx]
Sent: Thursday, October 17, 2019 12:33 PM
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxxxxxxxx>
Subject: Re: [IBMiOSS] End-user & native ODBC in Python
On Thu, Oct 17, 2019 at 12:52 PM Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:
I'm using the native ODBC driver. It works fine for me and another admin. We gave it to an end-user and it's failing. The first time there was an AF entry in the audit journal. We granted authority and it still fails (no new AF entries).
Error('00000', '[00000] [unixODBC][IBM][System i Access ODBC
Driver]CWBNL0203 - cwbodmsg.dll(2147483645) (2147483645)
(SQLDriverConnect)')
Suggestions?
First, just to be clear, all three of you (two admins and an end-user) are trying to initiate the ODBC connection from PASE? Everyone from the same LPAR, to the same LPAR?
I'm a little surprised the driver isn't 'IBM i Access ODBC Driver', but I don't know if that has anything to do with your issue.
John Y.
midrange.com
