Message-ID: <gh-postgresql-interfaces-psqlodbc-6-c2090315965@github.com>
From: "apgrucza (@apgrucza)" <noreply+apgrucza@github.com>
To: "postgresql-interfaces/psqlodbc" <noreply+postgresql-interfaces-psqlodbc@github.com>
Date: Thu, 02 May 2024 11:55:38 +0000
Subject: Re: [postgresql-interfaces/psqlodbc] PR #6: Use mimalloc to improve performance and reduce memory allocation lock contention
In-Reply-To: <gh-postgresql-interfaces-psqlodbc-6@github.com>
References: <gh-postgresql-interfaces-psqlodbc-6@github.com>
List-Id: <gh-postgresql-interfaces-psqlodbc.github.com>
X-GitHub-Author-Login: apgrucza
X-GitHub-Comment-Id: 2090315965
X-GitHub-Comment-Type: issue_comment
X-GitHub-Edited-At: 2024-05-02T11:58:18Z
X-GitHub-Issue: 6
X-GitHub-Repo: postgresql-interfaces/psqlodbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/postgresql-interfaces/psqlodbc/pull/6#issuecomment-2090315965
Content-Type: text/plain; charset=utf-8

I loaded `psqlodbc30a.dll` from both REL-16_00_0005 installers into [Dependencies](https://github.com/lucasg/Dependencies) to compare. For some reason the x64 one tries to load extra DLLs (libcrypto and libssl) via `libq.dll` but the x86 one doesn't. These DLLs fail to load (module could not be found on disk), which explains why only the x64 installer fails.

**x86**
![image](https://github.com/postgresql-interfaces/psqlodbc/assets/46910040/9f894450-b672-42e6-ae8f-011bec80a4e9)

**x64**
![image](https://github.com/postgresql-interfaces/psqlodbc/assets/46910040/ab3dfaf5-1216-4aad-96c9-77d9b6bf9a8b)

Neither MSI files include these DLLs:

**x86**
![image](https://github.com/postgresql-interfaces/psqlodbc/assets/46910040/ecefa2c6-236e-4df7-bac9-38e19f99f7f4)

**x64**
![image](https://github.com/postgresql-interfaces/psqlodbc/assets/46910040/364130bb-2428-4950-a8e1-428982d483d7)

If I compare with the MSIs from the last official release at https://www.postgresql.org/ftp/odbc/versions/msi/, libcrypto and libssl DLLs are present (and the x64 one has a few more: libiconv, libintl, libwinpthread):

**x86**
![image](https://github.com/postgresql-interfaces/psqlodbc/assets/46910040/55fad8e6-1497-46e8-bed2-0bd0f5d9c23c)

**x64**
![image](https://github.com/postgresql-interfaces/psqlodbc/assets/46910040/afff3e2c-bd5a-4788-a6d7-28a8718e3fc0)

So, I think the problem lies with these DLLs being absent from the MSI files.