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 1r57Xv-00BtPb-Ax for pgsql-odbc@arkaria.postgresql.org; Mon, 20 Nov 2023 16:54:51 +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 1r57Xq-009JF5-QC for pgsql-odbc@arkaria.postgresql.org; Mon, 20 Nov 2023 16:54:46 +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 1r57Xq-009JEx-AO for pgsql-odbc@lists.postgresql.org; Mon, 20 Nov 2023 16:54:46 +0000 Received: from pgintl.fastcrypt.com ([149.56.129.164]) by makus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r57Xl-006VUd-S1 for pgsql-odbc@postgresql.org; Mon, 20 Nov 2023 16:54:44 +0000 Received: from mail-ed1-f50.google.com (mail-ed1-f50.google.com [209.85.208.50]) by pgintl.fastcrypt.com (Postfix) with ESMTPSA id DF31820033 for ; Mon, 20 Nov 2023 11:54:40 -0500 (EST) Received: by mail-ed1-f50.google.com with SMTP id 4fb4d7f45d1cf-53e751aeb3cso6664749a12.2 for ; Mon, 20 Nov 2023 08:54:40 -0800 (PST) X-Gm-Message-State: AOJu0YzylueiHGNE00XrPFzSY9mzqXLmfbbltX+OnodXst5eY1J4oR+4 JSgCuP8ASJxtJ5BEgc33kCU7p29Lj8FpaUux9Wk= X-Google-Smtp-Source: AGHT+IFtQ+7lqdp+wcyvUCjgk9fhVsJfRDB/73cWETrLaP+lEP5oQPs0ZZb3ftt4KRBuAkhIHimzQpHeiVjVQ7ushFo= X-Received: by 2002:a05:6402:430b:b0:548:7a6f:b51e with SMTP id m11-20020a056402430b00b005487a6fb51emr6422715edc.14.1700499276779; Mon, 20 Nov 2023 08:54:36 -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> In-Reply-To: <108B98AF-447D-45D0-998F-561F38DDFFBF@savant.com> From: Dave Cramer Date: Mon, 20 Nov 2023 11:54:19 -0500 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: [EXT] ODBC driver on Windows 11 ARM64 To: Evan Cornell , Andres Freund Cc: "pgsql-odbc@postgresql.org" Content-Type: multipart/alternative; boundary="0000000000005557ad060a98575d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000005557ad060a98575d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable +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 needed t= o > access) > - > https://ftp.postgresql.org/pub/source/v13.10/postgresql-13.10.ta= r.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 Pl= atform > properties (e.g. MSBuild.exe Solution.sln /p:Configuration=3D= Debug > /p:Platform=3D"Any CPU") or leave those properties blank to u= se 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 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 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 m= uch >> 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 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 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 step= s? >>> >>> 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 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. >>> >>> >>> >>> 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-ma= il >>> 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. >>> >> >> > --0000000000005557ad060a98575d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

<= div dir=3D"ltr" class=3D"gmail_signature">


On Mon, 20 Nov 2023 at 11= :36, Evan Cornell <evan.corne= ll@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]

Tha= t 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.


--0000000000005557ad060a98575d--