unixODBC Driver Manager Can't open lib psqlodbca.so

[soky64]

Hi all,

I have an old Delphi3 application for our company business support.
It is connected a PostgreSQL database via ODBC driver (and BDE as Borland Database Engine)
It is working fine on native windows workstations. But I want to present it to mac users via VNC.

I set up a minimal graphical environment (openbox, xterm) on a linux server (ubuntu 22.04) and servicing via VNC (tightvnc) to mac user. My goal was to not have to install anything to mac, it has built in VNC client.

I set up also a working unixodbc to the database. The isql utility can connect and display the result of entered test query.

I didn't install mdac28 because documentation recommended unixodbc.
I created two overrides on winecfg for odbc32 and odbccp32 to builtin, although, I have a feeling this was the default.

I tried to trace it based on documentation via WINEDEBUG=+odbc32 then +all but nothing appeared on std out. (or where it should have appeared)

Just an error dialog (I have screenshot, but can I upload it here?)
[unixODBC][Driver Manager] Can't open lib 'psqlodbca.so' : file not found
Alias: MisDB

The system versions:
Ubuntu 22.04.4 LTS (GNU/Linux 5.15.0-112-generic x86_64)
wine --version
wine-6.0.3 (Ubuntu 6.0.3~repack-1)
(but I tried fresh one with same result)
I tried also with winetricks mdac28 without success.

I am asking for the help of the respected community in this.
Regards
Soky

[soky64]

Hm... The application is 32 bit, the WINEARCH=win32, however psqlodbca.so 64 bit, the hosting linux 64 bit also.
What is the correct configuration?
WINEARCH=64? Can it run the 32 bit app?
If it can do it, there is a chance to connect to 64 bit driver?