How can I connect to HFSQL C/S using python on Linux?

I am trying to connect to a legacy HFSQL (HyperFileSQL) Client/Server database using Python (pyodbc) on a Linux Ubuntu machine.

I have followed the official documentation to install the specific ODBC driver for Linux, but I keep getting an IM002 error indicating a disconnect between the Driver Manager and the configuration files.

System Setup:

• OS: Ubuntu 20.04 (approx)
• Driver: HFSQL ODBC Linux 64-bit (via install.sh)
• ODBC Manager: libiodbc2 libiodbc2-dev
• Python Package: pyodbc

Configuration Steps Taken:

• I installed the dependencies required by WinDev:

sudo apt-get install libiodbc2 libiodbc2-dev

• I installed the driver successfully. I verified the entry in /etc/odbcinst.ini:

[ODBC Drivers]
HFSQL = Installed
    
[HFSQL]
Description = HFSQL ODBC Driver
Driver = /home/datpandx/hfsql/wd250hfo64.so

• I configured a User DSN in ~/.odbc.ini:

[ODBC Data Sources]
HFSQL_FRUTAL = HFSQL
    
[HFSQL_FRUTAL]
Driver = HFSQL
Server Name = 26.***
Server Port = 4900
Database = ***
UID = ***
PWD = ***

Diagnostics: Running pyodbc.drivers() correctly lists 'HFSQL', which suggests Python can read the odbcinst.ini file. However, when inspecting the driver binary dependencies with ldd, I see it links to libiodbc, while pyodbc typically relies on unixODBC.

The Problem: When I try to connect using a DSN-less connection string (to rule out .ini file path issues), it fails immediately.

Code:

    import pyodbc
    
    print(f"Available Drivers: {pyodbc.drivers()}")
    # Output: ['ODBC Drivers', 'HFSQL']
    
    user = '***'
    password = '***'
    
    try:
        conn_str = (
            f"DSN={driver_name};"
            f"UID={user};"
            f"PWD={password};"
        )
    
        print(f"Trying to connect to: {driver_name} ...")
        conn = pyodbc.connect(conn_str)
        print("¡CONNECTED!")
        conn.close()
    
    except Exception as e:
        print("Fail")
        print(e)

The error:

['ODBC Drivers', 'HFSQL']
Trying to connect to: HFSQL_FRUTAL ...
Fail
('HY000', 'The driver did not supply an error!')

What I have tried:

• Verified file paths in /etc/odbcinst.ini are absolute and correct.
• Tried setting environment variables explicitly before running the script: export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/home/datpandx/hfsql
• Tried using the DSN approach (DSN=HFSQL_FRUTAL) with the same error
  result.

Is there a known solution between pyodbc and the HFSQL driver (which appears to depend on iODBC)? How can I bridge this gap on Linux?