Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rSjtA-00Fcnn-2z for pgsql-odbc@arkaria.postgresql.org; Wed, 24 Jan 2024 20:30:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rSjt8-008D7M-Vo for pgsql-odbc@arkaria.postgresql.org; Wed, 24 Jan 2024 20:30:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rSjt8-008D7E-G3 for pgsql-odbc@lists.postgresql.org; Wed, 24 Jan 2024 20:30:22 +0000 Received: from pgintl.fastcrypt.com ([149.56.129.164]) by makus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rSjt4-003BPC-VY for pgsql-odbc@postgresql.org; Wed, 24 Jan 2024 20:30:21 +0000 Received: from mail-wm1-f50.google.com (mail-wm1-f50.google.com [209.85.128.50]) by pgintl.fastcrypt.com (Postfix) with ESMTPSA id 8E8B220033 for ; Wed, 24 Jan 2024 15:30:17 -0500 (EST) Received: by mail-wm1-f50.google.com with SMTP id 5b1f17b1804b1-40eacb4bfa0so39669465e9.1 for ; Wed, 24 Jan 2024 12:30:17 -0800 (PST) X-Gm-Message-State: AOJu0YzgOPhtgOZnJ3Z6eIxGllwJ5zmWA3/HYS7HZerd6CkeTZha1jMK 8XXpYNY+wRv8p/wHpfgVuFRzfxOwCMo9LjJCVy0K7nfdNNlV9+0YzDThmi9yTndAii31LW59myb 3gRO3ofxvrO2V1HepQ0iBnTxiIsE= X-Google-Smtp-Source: AGHT+IHzcrqCBiEP3SjZ8WeuG5G8+a2grI8EFQ2eRlCVQuzN+fyf6LmH6KQ/Y0mgD//ZUsbmvAc8fxNGsCuawdaY8Dk= X-Received: by 2002:a05:600c:4248:b0:40e:44c2:a3ed with SMTP id r8-20020a05600c424800b0040e44c2a3edmr1337100wmm.61.1706128216378; Wed, 24 Jan 2024 12:30:16 -0800 (PST) MIME-Version: 1.0 References: <51CC77CE-1A95-4351-B225-1AF76B0D7D6B@savant.com> <2910E8F4-5C51-4C18-B968-F8D867F2B8D1@savant.com> <108B98AF-447D-45D0-998F-561F38DDFFBF@savant.com> <41488853-E5FD-4420-B77B-957B37158FBF@savant.com> In-Reply-To: From: Dave Cramer Date: Wed, 24 Jan 2024 15:29:58 -0500 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: [EXT] ODBC driver on Windows 11 ARM64 To: Evan Cornell Cc: Andres Freund , "pgsql-odbc@postgresql.org" Content-Type: multipart/alternative; boundary="0000000000004758cc060fb6ee13" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004758cc060fb6ee13 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, 21 Nov 2023 at 09:36, Evan Cornell wrote: > Dave, > > Very good. I=E2=80=99ll spend a little time trying out Meson build on lat= est > versions of everything. I=E2=80=99ll document my steps as I go. > > Thanks, > > *Evan Cornell* > Hardware Engineering > C. 419.706.8315 > 45 Perseverance Way > Hyannis, MA 02601 > > evan.cornell@savant.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 recipien= t, > please immediately notify the sender by reply e-mail or at 508.683.2500 a= nd > delete this message and its attachments, if any. > > On Nov 21, 2023, at 9:34=E2=80=AFAM, Dave Cramer > wrote: > > > > On Tue, 21 Nov 2023 at 09:33, Evan Cornell > wrote: > >> Can meson build be done from Windows 11 VM? >> > > I think you are in uncharted territory here. Hence my adding Andres to th= e > 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.cornell@savant.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 recipie= nt, >> 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=E2=80=AFAM, Dave Cramer >> wrote: >> >> >> +Andres Freund >> >> >> On Mon, 20 Nov 2023 at 11:36, Evan Cornell >> wrote: >> >>> Dave, >>> >>> Here=E2=80=99s 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 . *(fro= m >>> 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.ex= e >>> - 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 n= eeded >>> 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 inv= alid. Please >>> specify a valid solution configuration using the Configurat= ion and Platform >>> properties (e.g. MSBuild.exe Solution.sln /p:Configuration= =3DDebug >>> /p:Platform=3D"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 >> >> >> 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 confidentia= l >>> 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 thi= s >>> transmission in error, any use, reproduction or dissemination of this >>> transmission is strictly prohibited. If you are not the intended recipi= ent, >>> 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=E2=80=AFAM, Dave Cramer >>> 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 >>> wrote: >>> >>>> Is there anyone who could help out with this? I=E2=80=99ve 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.cornell@savant.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 informatio= n may >>>> also be legally privileged. This transmission is sent in trust, and th= e >>>> sole purpose of delivery to the intended recipient. If you have receiv= ed >>>> this transmission in error, any use, reproduction or dissemination of = this >>>> transmission is strictly prohibited. If you are not the intended recip= ient, >>>> please immediately notify the sender by reply e-mail or at 508.683.250= 0 and >>>> delete this message and its attachments, if any. >>>> >>>> On Nov 1, 2023, at 8:32 AM, Dave Cramer >>>> 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 >>>> >>>> >>>> And then use that to compile ODBC. >>>> >>>> Directions for compiling ODBC Compiling psqlODBC on Windows >>>> (postgresql.org) >>>> >>>> Dave Cramer >>>> www.postgres.rocks >>>> >>>> >>>> On Wed, 1 Nov 2023 at 05:29, Evan Cornell >>>> 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.cornell@savant.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 informati= on may >>>>> also be legally privileged. This transmission is sent in trust, and t= he >>>>> sole purpose of delivery to the intended recipient. If you have recei= ved >>>>> this transmission in error, any use, reproduction or dissemination of= this >>>>> transmission is strictly prohibited. If you are not the intended reci= pient, >>>>> please immediately notify the sender by reply e-mail or at 508.683.25= 00 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. I= f 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 intend= ed >>>>> recipient but do not wish to receive communications through this medi= um, >>>>> please so advise the sender immediately. >>>>> >>>> >>>> >>> >> > Hi Evan, I've been able to build psqlodbc on windows 11 pro ARM. Now getting the installer to build. Wix has to be upgraded to v4 and then wix used instead of candle. Any progress on your end ? Dave --0000000000004758cc060fb6ee13 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable



<= br>
On Tue,= 21 Nov 2023 at 09:36, Evan Cornell <evan.cornell@savant.com> wrote:
Dave,

Very good. I=E2=80=99ll spend a little time trying out Meson build on = latest versions of everything. I=E2=80=99ll document my steps as I go.

Thanks,

Evan Cornell
Hardware Engineering
C. 419.706.8315
45 Perseverance Way
Hyannis, MA 02601
www.savant.com



Statement of Confidentiality

The contents of this e-mail message and any attachments are confidential an= d are intended solely for the addressee. The information may also be legall= y privileged. This transmission is sent in trust, and the sole purpose of d= elivery 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 t= he 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 21, 2023, at 9:34=E2=80=AFAM, Dave Cramer <davecramer@postgr= es.rocks> wrote:



On Tue, 21 Nov 2023 at 09:33, Evan Co= rnell <evan= .cornell@savant.com> wrote:
Can meson build be done from Windows 11 VM?=C2=A0

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

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

The latest should work fine.

Dave=C2=A0

Thanks,


On Nov 20, 2023, at 11:54=E2=80=AFAM, Dave Cramer <davecramer@postg= res.rocks> wrote:


On Mon, 20 Nov 2023 at 11:36, Evan Co= rnell <evan= .cornell@savant.com> wrote:
Dave,

Here=E2=80=99s my steps so far:
  1. Create windows 11 virtual machine (Parallels Desktop 19 for Mac - runni= ng on Mac Studio M1 Max)
  2. Referencing=C2=A0https://w= ww.postgresql.org/docs/13/install-windows-full.html=C2=A0for all build = system requirements
  3. Install Windows Visual Studio Community 2022=C2= =A0
    • check "Desktop development with C++" during Visual Studio Com= munity 2022 installation
  4. Install ActiveState Perl 5.36.1
    • state checkout evan-cornell-savant/Perl-5.36.1-Windows .=C2=A0(f= rom Powershell)
    • state use Perl-5.36.1-Windows=C2=A0(from Pow= ershell)
  5. Install ActiveState TCL
    • ActiveTcl-8.6.13.0000-MSWin32-x64-559160e0.msi
  6. Install MSYS2 for Bison and Flex
  7. Install GnuWin32 for Diff, Gettext
  8. Install=C2=A0MIT Kerberos
  9. Install libxml2 & libxslt
    • https:/= /zlatkovic.com/pub/libxml/
    • iconv-1.9.2.win32.zip
    • libxml= 2-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
  11. Install Python
  12. Download source for Postgresql v13.10 (This is the version that is runn= ing 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=C2=A0postgre= sql-13.10=C2=A0folder to C:\
      • start=C2=A0ARM64 Native Tools C= ommand Prompt for VS 2022
      • cd C:\postgresql-13.10\src\tools\m= svc
      • build
        • errorProject "C:\postgresql-13.10\pgsql.sln" on node 1 (d= efault targets).=C2=A0
          C:\postgresql-13.10\pgsql.sln.metaproj : error MSB4126: The specifi= ed solution configuration "Release|arm64" is invalid. Please spec= ify a valid solution configuration using the Configuration and Platform pro= perties (e.g. MSBuild.exe Solution.sln /p:Configuration=3DDebug /p:Platform=3D"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!

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 an= d are intended solely for the addressee. The information may also be legall= y privileged. This transmission is sent in trust, and the sole purpose of d= elivery 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 t= he 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=E2=80=AFAM, Dave Cramer <davecramer@postgr= es.rocks> wrote:

What issues are you running=C2=A0into?

Can you post the errors ?

Dave Cramer
www.postgres.rocks


On Mon, 20 Nov 2023 at 09:18, Evan Co= rnell <evan= .cornell@savant.com> wrote:
Is there anyone who could help out with this? I=E2=80=99ve been having= much difficulty attempting to compile Postgresql ODBC drivers for win11 AR= M successfully.




On Nov 1, 2023, at 8:32 AM, Dave Cramer <davecramer@postgres.rocks&= gt; wrote:


On Wed, 1 Nov 2023 at 05:29, Evan Cor= nell <evan.= cornell@savant.com> wrote:
Is it possible to install postgresql ODBC driver on Windows 11 ARM64?= =C2=A0

If required to manually compile, this is fine, if so, what are the ste= ps?

Thanks,




CONFIDENTIALITY NOTICE:
This message may contain confidential and/or privileged material. Any unaut= horized review, use, disclosure or distribution is prohibited. If you are n= ot the intended recipient, please contact the sender by reply e-mail and de= stroy all copies of the original message. If you are the intended recipient but do not wish to receive comm= unications through this medium, please so advise the sender immediately.