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 1r5RqO-00DWfG-0x for pgsql-odbc@arkaria.postgresql.org; Tue, 21 Nov 2023 14:35:16 +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 1r5RqM-00HP0q-Nh for pgsql-odbc@arkaria.postgresql.org; Tue, 21 Nov 2023 14:35:14 +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 1r5RqM-00HP0i-7Z for pgsql-odbc@lists.postgresql.org; Tue, 21 Nov 2023 14:35:14 +0000 Received: from pgintl.fastcrypt.com ([149.56.129.164]) by makus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r5RqI-006egw-PF for pgsql-odbc@postgresql.org; Tue, 21 Nov 2023 14:35:13 +0000 Received: from mail-ed1-f51.google.com (mail-ed1-f51.google.com [209.85.208.51]) by pgintl.fastcrypt.com (Postfix) with ESMTPSA id 9893F202C0 for ; Tue, 21 Nov 2023 09:35:09 -0500 (EST) Received: by mail-ed1-f51.google.com with SMTP id 4fb4d7f45d1cf-548c548c40aso3766019a12.0 for ; Tue, 21 Nov 2023 06:35:09 -0800 (PST) X-Gm-Message-State: AOJu0YzmJfoyHmDipDIkQwf1MfS4nrlCUqfe4sRXlc9NQuN4CsGf1m1u DrftZcUwX9ALnsMQ8EzPssET2FOLkppQpMte56Q= X-Google-Smtp-Source: AGHT+IFCz5qI1HfbwQ8Lp0SofGr8N4fLS3k4//eRZSu3mlg0R9GqjgpcovH80cGC9Zkn8jBH+0nnUWU+s2urKxMzqjU= X-Received: by 2002:aa7:c04b:0:b0:543:5dd9:a72 with SMTP id k11-20020aa7c04b000000b005435dd90a72mr2253424edo.1.1700577306233; Tue, 21 Nov 2023 06:35:06 -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: <41488853-E5FD-4420-B77B-957B37158FBF@savant.com> From: Dave Cramer Date: Tue, 21 Nov 2023 09:34:48 -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="0000000000004052c3060aaa828d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004052c3060aaa828d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 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.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 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 . *(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 ne= eded >> to access) >> - >> https://ftp.postgresql.org/pub/source/v13.10/postgresql-13.10.t= ar.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 P= latform >> 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 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 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 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 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 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. >>>> >>>> >>>> >>>> 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-m= ail >>>> and destroy all copies of the original message. If you are the intende= d >>>> recipient but do not wish to receive communications through this mediu= m, >>>> please so advise the sender immediately. >>>> >>> >>> >> > --0000000000004052c3060aaa828d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Tue, 21 Nov = 2023 at 09:33, Evan Cornell <= 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 A= ndres 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,

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 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.



--0000000000004052c3060aaa828d--