Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Python ODBC connection via ODBX to Informix SE C-ISAM Databases

    Posted 14 hours ago

    I've installed the ibm.csdk.4.50.12.Linux.64.x86_64 on my Rhel 9 system together with unixODBC and I connect with success via bash shell to my Informix SE C-ISAM Databases.
    When I try to connect using Python with PyOdbc module, using the same DSN configured and working in shell, I receive a *** buffer overflow detected ***: terminated
    Aborted (core dumped).
    Some usefull information about it?

    Thanks



    ------------------------------
    Roberto Antonetti Lamorgese Passeri
    ------------------------------


  • 2.  RE: Python ODBC connection via ODBX to Informix SE C-ISAM Databases

    Posted 12 hours ago
    Revert the driver, the latest doesn't work.  

    On 11/7/2025 8:34 AM, Roberto Antonetti Lamorgese Passeri via IBM TechXchange Community wrote:
    0100019a5ebd201d-d67f42bb-dbac-4a59-9e19-b45992f79fd2-000000@email.amazonses.com">
    I've installed the ibm.csdk.4.50.12.Linux.64.x86_64 on my Rhel 9 system together with unixODBC and I connect with success via bash shell to my... -posted to the "Informix" group



    Original Message


  • 3.  RE: Python ODBC connection via ODBX to Informix SE C-ISAM Databases

    Posted 12 hours ago
    Looking back at my test harnesses, I went the PyODBC route as I can to do connect to both Informix and MySQL

    #! /usr/bin/python

    import pyodbc
    print(pyodbc.version)
    print(pyodbc.dataSources())

    conn = pyodbc.connect(

        "DRIVER=IBM Informix ODBC DRIVER;"

        "HOST=xx.xx.xx.xx;"

        "SERVER=dbstage2;"

        "SERVICE=1524;"

        "DATABASE=sysmaster;"

        "PROTOCOL=onsoctcp;"

        "UID=informix;"

        "PWD=informix"
        )

    input("Press any key to continue...")
    prod-dbstage: ./test.py
    4.0.39
    {'xxxx'}
    Press any key to continue...

    On 11/7/2025 9:47 AM, Paul Watson via IBM TechXchange Community wrote:
    0100019a5f004934-3dd27769-f63a-43fb-b9ce-f5f404cb5b6b-000000@email.amazonses.com">
    Revert the driver, the latest doesn't work. On 11/7/2025 8:34 AM, Roberto Antonetti Lamorgese Passeri via IBM TechXchange... -posted to the "Informix" group



    Original Message


Related Content