Re: Conexion between Python and IBM i

[Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>]

Okay, Eduardo Marcó, here's the answer:

   1. If you connect remotely using ibm_db_dbi you must:
      1. Have a Db2Connect license (expensive)
      2. Connect on port 446 the DRDA port
   2. If you connect from onboard your IBM i, you don't need the Db2Connect
   license, and your connection looks like
   import ibm_db_dbi
   dsn="DATABASE=*whatever*;UID=*youruid*;PWD=*yourpassword*"
   conn = ibm_db_dbi.connect(dsn, '', '')
   3. For remote connectivity without license fee, use ODBC.
   <https://www.seidengroup.com/open-source-documentation/>


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

> 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?