Re: Conexion between Python and IBM i

Take a look at my repo - it will walk you through all the dettings; Perhaps
you ODBC is not setup corectly.

https://github.com/NielsLiisberg/Python-FastAPI-demo



On Fri, May 26, 2023 at 8:46 PM Jack Woehr via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

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?

--

*JACK WOEHR, IBM Champion 2021-2023
<https://www.credly.com/users/jack-woehr/badges>*

*SENIOR IBM i ENGINEER*

303.847.8442
jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx
<https://www.linkedin.com/in/jackwoehr/> stay connected
<https://www.linkedin.com/company/absolute-performance-inc./>

<https://www.absolute-performance.com/>
www.absolute-performance.com

NON-DISCLOSURE NOTICE: This communication including any and all
attachments is for the intended recipient(s) only and may contain

confidential and privileged information. If you are not the intended
recipient of this communication, any disclosure, copying further

distribution or use of this communication is prohibited. If you received
this communication in error, please contact the sender and

delete/destroy all copies of this communication immediately.
--
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.