Python ODBC connection via ODBX to Informix SE C-ISAM Databases
Posted in 2025
Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET
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 ------------------------------
Revert the driver, the latest doesn't work. On 11/7/2025 8:34 AM, Roberto Antonetti Lamorgese Passeri via IBM TechXchange Community wrote:
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...