[Python] 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?

Continue reading...