[Python] Issue with connecting with DB2 database using ibm_db library

Discussão em 'Python' iniciado por Stack, Novembro 27, 2024.

  1. Stack

    Stack Membro Participativo

    I have some issue with connecting with DB2 database using "ibm_db" library. Here is my code and error which I received after running it:

    import ibm_db

    dsn = (
    "DATABASE=***;"
    "HOSTNAME=***;"
    "PORT=***;"
    "PROTOCOL=TCPIP;"
    "UID=***;"
    "PWD=***;")

    try:
    conn = ibm_db.connect(dsn, "", "")
    except Exception as e:
    print("Error:", ibm_db.conn_errormsg())


    Error:


    [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "9.214.130.103". Communication function detecting the error: "recv". Protocol specific error code(s): "10054", "*", "0". SQLSTATE=08001 SQLCODE=-30081
    ​

    I tried to find some description and root cause specific error 10054, but I cannot find any resolution for that.

    Continue reading...

Compartilhe esta Página