Obtaining IBM ODBC driver for Informix
Bob Kline, triaging pyodbc tickets about Informix connections, asked how to get the IBM ODBC driver. Paul Watson said to download the CSDK from IBM Fix Central, that the latest pyodbc failed with the newest driver (buffer overflow, IBM case open), and that he used driver 4.0.39 plus UTF-8 setdecoding/setencoding calls to fix locale issues. Bob would investigate further.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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...
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...
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 ------------------------------
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...
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
Thanks, Paul. -- Bob Kline https://www.rksystems.com mailto: bkline@rksystems.com