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.  Obtaining IBM ODBC driver for Informix

    Posted Tue February 17, 2026 09:35 AM
    Download the CSDK from IBM  fixcentral/PA site (good luck finding it though)

    Note - the latest pyodbc will not (or didn't work) with the latest ODBC driver, I need revert back a revision on the pyodbc.  If you search the list you should be able to find what I got to work

    On 2/17/2026 8:29 AM, Bob Kline via IBM TechXchange Community wrote:
    0100019c6c013501-4a6ddd56-1545-47f1-8026-ba2c297263b7-000000@email.amazonses.com">
    I'm working on triaging tickets for the pyodbc project. A number of those tickets report problems connecting to Informix. How can I get a copy of...


  • 2.  RE: Obtaining IBM ODBC driver for Informix

    Posted Tue February 17, 2026 09:39 AM
    I used this version of the driver  4.0.39

    On 2/17/2026 8:29 AM, Bob Kline via IBM TechXchange Community wrote:
    0100019c6c01357e-97523980-1f36-4d68-8ace-c593d6443678-000000@email.amazonses.com">
    I'm working on triaging tickets for the pyodbc project. A number of those tickets report problems connecting to Informix. How can I get a copy of...





  • 3.  RE: Obtaining IBM ODBC driver for Informix

    Posted Tue February 17, 2026 11:35 AM

    Thanks, Paul. I'm digging in to see if there's a way to get pyodbc able to connect with the latest version. Will circle back with an update here if I'm successful.



    ------------------------------
    Bob Kline
    ------------------------------



  • 4.  RE: Obtaining IBM ODBC driver for Informix

    Posted Tue February 17, 2026 12:02 PM
    IBM accepted it was known with the latest pyodbc driver, I need to see if they accepted it as a bug

    On 2/17/2026 10:34 AM, Bob Kline via IBM TechXchange Community wrote:
    0100019c6c74448c-75405cdc-7733-4707-a7d5-e986e044f724-000000@email.amazonses.com">
    Thanks, Paul. I'm digging in to see if there's a way to get pyodbc able to connect with the latest version. Will circle back with an update here...



    Original Message


  • 5.  RE: Obtaining IBM ODBC driver for Informix

    Posted Tue February 17, 2026 12:10 PM
    if you log with IBM then this is the case I had open TS019563391

    ./odbc_test.py
    INFORMIXDIR = /informix/csdk450fc11w1
    INFORMIXSQLHOSTS = /home/informix/etc/sqlhosts
    INFORMIXSERVER = dbstage
    LD_LIBRARY_PATH = /informix/csdk450fc11w1/lib/cli:/informix/csdk450fc11w1/lib/esql:/informix/csdk450fc11w1/lib:/informix/csdk450fc11w1/lib/esql
    ODBCINI = /etc/odbc.ini
    ODBCSYSINI = /etc
    *** buffer overflow detected ***: terminated

    also had locale issues, and did this to fix it 

    conn_ifx = pyodbc.connect(

    "DRIVER=IBM Informix ODBC DRIVER;"

    "HOST=xxxxxx;"

    "SERVER=xxxxx;"

    "SERVICE=xxxxx;"

    "DATABASE=sysmaster;"

    "PROTOCOL=onsoctcp;"

    "UID=informix;"

    "PWD=xxxxxxx"

    )

    conn_ifx.setdecoding(pyodbc.SQL_WCHAR, encoding='UTF-8')

    conn_ifx.setdecoding(pyodbc.SQL_CHAR, encoding='UTF-8')

    conn_ifx.setencoding(encoding='UTF-8')




    On 2/17/2026 11:02 AM, Paul Watson via IBM TechXchange Community wrote:
    0100019c6c8d953a-9815aef6-03d8-4f09-891b-1f94e3baa567-000000@email.amazonses.com">
    IBM accepted it was known with the latest pyodbc driver, I need to see if they accepted it as a bug On 2/17/2026 10:34 AM, Bob... -posted to the "Informix" group



    Original Message


  • 6.  RE: Obtaining IBM ODBC driver for Informix

    Posted Tue February 17, 2026 01:35 PM
    Thanks, Paul.

    --



    Original Message


Related Content