[Python] Facing GSKit Error: 17". SQLSTATE=42724 SQLCODE=-1109 Error While Connecting from...

Discussão em 'Python' iniciado por Stack, Janeiro 15, 2025.

  1. Stack

    Stack Membro Participativo

    I am Trying to Connect DB2 Data base from Python program using ibm_db api. But i am getting below issue...

    Connection failed: [IBM][CLI Driver] SQL1109N The command was not processed because the database manager failed to load the following DLL: "GSKit Error: 17". SQLSTATE=42724 SQLCODE=-1109

    Below is my code...

    import os
    os.add_dll_directory(r'C:\Users\x\AppData\Roaming\Python\Python313\site-packages\clidriver\bin')
    import ibm_db
    import ibm_db_sa
    conn_str = (
    "DATABASE=x;"
    "HOSTNAME=x;"
    "PORT=50001;"
    "PROTOCOL=TCPIP;"
    "UID=x;"
    "PWD=x;"
    "SECURITY=SSL;"
    "SSLServerCertificate=C:\\cert\\db2cert\\xprdb2watom1_cacerts"
    )

    try:
    conn = ibm_db.connect(conn_str, "", "")
    print("Connection successful!")
    except Exception as e:
    print(f"Connection failed: {e}")

    Continue reading...

Compartilhe esta Página