Skip to content

SQL27001 Read error when connecting to Informix using IfxPy in Python #85

@Aymen1617

Description

@Aymen1617
Image

Environment:

  • Python 3.10 in WSL Ubuntu
  • IfxPy installed in virtual environment
  • IBM Informix Client-SDK 4.50.FC12W5 installed
  • INFORMIXDIR, LD_LIBRARY_PATH, PATH, CLIENT_LOCALE, DB_LOCALE, and INFORMIXSERVER exported correctly
  • SQLHOSTS entry is done
    Problem:

When running Python script:

import IfxPy

conn_str = (
    "SERVER=***;"
    "DATABASE=***;"
    "UID=****;"
    "PWD=*****"  
)

conn = IfxPy.connect(conn_str, "", "")

Error:
  Traceback (most recent call last):
    File "/mnt/d/shared/code/test_ifx_connection.py", line 16, in <module>
      conn = IfxPy.connect(conn_str, "", "")
  

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions