Re: Conexion between Python and IBM i

If it is DRDA, then yes, it is a keyed product.

I was under the impression that the recommended method was ODBC with the drivers supplied by IBM that run on IBM i ? ( or if from off platform the ones supplied with ACS full package download ) That as opposed to the other potential solutions simply because it has been optimized for the environment.

Jim Oberholtzer
Agile Technology Architects

On May 26, 2023, at 11:55 AM, Richard Schoen <richard@xxxxxxxxxxxxxxxxx> wrote:

I wonder if the driver in question is part of the licensable DB2 connect product.

As Jack mentioned ODBC is probably your best answer.

Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
------------------------------

message: 3
date: Fri, 26 May 2023 10:41:19 -0600
from: Jack Woehr via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>
subject: Re: Conexion between Python and IBM i

I can connect via PORT=446 but get:

Exception: [IBM][CLI Driver] SQL1598N An attempt to connect to the database server failed because of a licensing problem. SQLSTATE=42968
SQLCODE=-1598

ODBC works. Can you use ODBC instead?

On Fri, May 26, 2023 at 10:35?AM Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

I'm exploring this and will post back when I figure it out!! :)

On Fri, May 26, 2023 at 10:22?AM Eduardo Marc?
<eduardomarco@xxxxxxxxx>
wrote:

I try, but the same error

Em sex., 26 de mai. de 2023 ?s 12:38, Marc Rauzier <
marc.rauzier@xxxxxxxxx>
escreveu:

Le 26/05/2023 ? 17:35, Eduardo Marc? a ?crit :

There?s only one entry IBMI01

So you may want to try

dsn =

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

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.