Re: Conexion between Python and IBM i

I use the name of WRKRDBDIRE, but i can´t access.
Traceback (most recent call last):
File "C:\Users\Pessoal\Curso Python\pythonProject3\venv\conibm_db.py",
line 7, in <module>
conn = ibm_db_dbi.connect(dsn)
^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Pessoal\Curso
Python\pythonProject3\venv\Lib\site-packages\ibm_db_dbi.py", line 634, in
connect
raise _get_exception(inst)
ibm_db_dbi.ProgrammingError: ibm_db_dbi::ProgrammingError: [IBM][CLI
Driver] SQL1013N The database alias name or database name "" could not be
found. SQLSTATE=42705 SQLCODE=-1013

Em sex., 26 de mai. de 2023 às 11:20, Jack Woehr via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> escreveu:

I think you're putting a schema name in the DATABASE= portion of the
connection string
You want the name of the *database* as defined in WRKRDBDIRE

On Fri, May 26, 2023 at 7:38 AM Eduardo Marcó <eduardomarco@xxxxxxxxx>
wrote:

I want to connect IBM i using IBM_DB function, but i can´t connect

because

don´t recognize the database name in parameter conexion, I use my

library.

import ibm_db_dbi

# Set up the connection parameters
dsn =

"DATABASE=eamarco;HOSTNAME=192.168.50.225;PORT=922;PROTOCOL=TCPIPtelnet;UID=username;PWD=password"

--

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