Re: [EXT] ODBC driver on Windows 11 ARM64

+Andres Freund <andres(at)anarazel(dot)de>

On Mon, 20 Nov 2023 at 11:36, Evan Cornell <evan(dot)cornell(at)savant(dot)com> wrote:

> Dave,
>
> Here’s my steps so far:
>
> 1. Create windows 11 virtual machine (Parallels Desktop 19 for Mac -
> running on Mac Studio M1 Max)
> 2. Referencing
> https://www.postgresql.org/docs/13/install-windows-full.html for all
> build system requirements
> 3. Install Windows Visual Studio Community 2022
> - check "Desktop development with C++" during Visual Studio
> Community 2022 installation
> 4. Install ActiveState Perl 5.36.1
> - *state checkout evan-cornell-savant/Perl-5.36.1-Windows . *(from
> Powershell)
> - *state use Perl-5.36.1-Windows *(from Powershell)
> 5. Install ActiveState TCL
> - ActiveTcl-8.6.13.0000-MSWin32-x64-559160e0.msi
> 6. Install MSYS2 for Bison and Flex
> - https://www.msys2.org/
> - msys2-x86_64-20231026.exe
> 7. Install GnuWin32 for Diff, Gettext
> - https://sourceforge.net/projects/getgnuwin32/files/
> - GetGnuWin32-0.6.3.exe
> - change install path to C:\gnuwin32
> - add C:\gnuwin32\bin to system PATH environment variable
> 8. Install MIT Kerberos
> - https://web.mit.edu/Kerberos/dist/index.html
> - kfw-4.1-amd64.msi
> 9. Install libxml2 & libxslt
> - https://zlatkovic.com/pub/libxml/
> - iconv-1.9.2.win32.zip
> - libxml2-2.7.8.win32.zip
> - libxslt-1.1.26.win32.zip
> - unzip all 3 to C:\ and add the xxxx\bin subfolders to system PATH
> environment variable
> 10. Install OpenSSL
> - https://slproweb.com/products/Win32OpenSSL.html
> - Win64ARMOpenSSL-3_1_4.msi
> 11. Install Python
> - https://www.python.org/ftp/python/3.12.0/python-3.12.0-arm64.exe
> - python-3.12.0-arm64.exe
> - use admin privileges when installing; add python.exe to PATH
> - Disable path length limit
> 12. Download source for Postgresql v13.10 (This is the version that
> is running on the database that the ODBC driver is ultimately needed to
> access)
> -
> https://ftp.postgresql.org/pub/source/v13.10/postgresql-13.10.tar.bz2
> - copy *postgresql-13.10 *folder to C:\
> - start* ARM64 Native Tools Command Prompt for VS 2022*
> - *cd C:\postgresql-13.10\src\tools\msvc*
> - *build*
> - *errorProject "C:\postgresql-13.10\pgsql.sln" on node 1
> (default targets). *
> *C:\postgresql-13.10\pgsql.sln.metaproj : error MSB4126: The
> specified solution configuration "Release|arm64" is invalid. Please specify
> a valid solution configuration using the Configuration and Platform
> properties (e.g. MSBuild.exe Solution.sln /p:Configuration=Debug
> /p:Platform="Any CPU") or leave those properties blank to use the default
> solution configuration. [C:\postgresql-13.10\pgsql.sln]*
>
>
That would certainly be a blocker!
I would try building it with Meson. PostgreSQL: Documentation: 16:
17.4. Building and Installation with Meson
<https://www.postgresql.org/docs/current/install-meson.html>

Andres may be able to help with that. I've added him to the thread

Dave

> Statement of Confidentiality
>
> The contents of this e-mail message and any attachments are confidential
> and are intended solely for the addressee. The information may also be
> legally privileged. This transmission is sent in trust, and the sole
> purpose of delivery to the intended recipient. If you have received this
> transmission in error, any use, reproduction or dissemination of this
> transmission is strictly prohibited. If you are not the intended recipient,
> please immediately notify the sender by reply e-mail or at 508.683.2500 and
> delete this message and its attachments, if any.
>
> On Nov 20, 2023, at 9:25 AM, Dave Cramer <davecramer(at)postgres(dot)rocks>
> wrote:
>
> What issues are you running into?
>
> Can you post the errors ?
>
> Dave Cramer
> www.postgres.rocks
>
>
> On Mon, 20 Nov 2023 at 09:18, Evan Cornell <evan(dot)cornell(at)savant(dot)com>
> wrote:
>
>> Is there anyone who could help out with this? I’ve been having much
>> difficulty attempting to compile Postgresql ODBC drivers for win11 ARM
>> successfully.
>>
>>
>>
>> *Evan Cornell*
>> Hardware Engineering
>> C. 419.706.8315
>> 45 Perseverance Way
>> Hyannis, MA 02601
>>
>> evan(dot)cornell(at)savant(dot)com
>> www.savant.com
>>
>>
>>
>> Statement of Confidentiality
>>
>> The contents of this e-mail message and any attachments are confidential
>> and are intended solely for the addressee. The information may also be
>> legally privileged. This transmission is sent in trust, and the sole
>> purpose of delivery to the intended recipient. If you have received this
>> transmission in error, any use, reproduction or dissemination of this
>> transmission is strictly prohibited. If you are not the intended recipient,
>> please immediately notify the sender by reply e-mail or at 508.683.2500 and
>> delete this message and its attachments, if any.
>>
>> On Nov 1, 2023, at 8:32 AM, Dave Cramer <davecramer(at)postgres(dot)rocks>
>> wrote:
>>
>> Hi Evan,
>>
>> Yes, it would require manually compiling. Looks like you will have to
>> first compile PostgreSQL on your machine.
>> PostgreSQL: Documentation: 16: 18.1. Building with Visual C++ or the
>> Microsoft Windows SDK
>> <https://www.postgresql.org/docs/current/install-windows-full.html>
>>
>> And then use that to compile ODBC.
>>
>> Directions for compiling ODBC Compiling psqlODBC on Windows
>> (postgresql.org)
>> <https://odbc.postgresql.org/docs/win32-compilation.html>
>> Dave Cramer
>> www.postgres.rocks
>>
>>
>> On Wed, 1 Nov 2023 at 05:29, Evan Cornell <evan(dot)cornell(at)savant(dot)com>
>> wrote:
>>
>>> Is it possible to install postgresql ODBC driver on Windows 11 ARM64?
>>>
>>> If required to manually compile, this is fine, if so, what are the steps?
>>>
>>> Thanks,
>>>
>>> *Evan Cornell*
>>> Hardware Engineering
>>> C. 419.706.8315
>>> 45 Perseverance Way
>>> Hyannis, MA 02601
>>>
>>> evan(dot)cornell(at)savant(dot)com
>>> www.savant.com
>>>
>>>
>>>
>>> Statement of Confidentiality
>>>
>>> The contents of this e-mail message and any attachments are confidential
>>> and are intended solely for the addressee. The information may also be
>>> legally privileged. This transmission is sent in trust, and the sole
>>> purpose of delivery to the intended recipient. If you have received this
>>> transmission in error, any use, reproduction or dissemination of this
>>> transmission is strictly prohibited. If you are not the intended recipient,
>>> please immediately notify the sender by reply e-mail or at 508.683.2500 and
>>> delete this message and its attachments, if any.
>>>
>>>
>>>
>>> CONFIDENTIALITY NOTICE:
>>> This message may contain confidential and/or privileged material. Any
>>> unauthorized review, use, disclosure or distribution is prohibited. If you
>>> are not the intended recipient, please contact the sender by reply e-mail
>>> and destroy all copies of the original message. If you are the intended
>>> recipient but do not wish to receive communications through this medium,
>>> please so advise the sender immediately.
>>>
>>
>>
>