Re: [EXT] ODBC driver on Windows 11 ARM64

On Tue, 21 Nov 2023 at 09:33, Evan Cornell <evan(dot)cornell(at)savant(dot)com> wrote:

> Can meson build be done from Windows 11 VM?
>

I think you are in uncharted territory here. Hence my adding Andres to the
discussion.

>
> Also, if the database I need to access is running Postgresql v13.10, do I
> need to build that version of postgresql and postgresql odbc drivers, or
> ought I to just use the latest versions?
>

The latest should work fine.

Dave

>
> 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.
>
> On Nov 20, 2023, at 11:54 AM, Dave Cramer <davecramer(at)postgres(dot)rocks>
> wrote:
>
>
> +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.
>>>>
>>>
>>>
>>
>