Re: [EXT] ODBC driver on Windows 11 ARM64 - Mailing list pgsql-odbc

On Nov 21, 2023, at 9:34 AM, Dave Cramer <davecramer@postgres.rocks> wrote:

On Tue, 21 Nov 2023 at 09:33, Evan Cornell <evan.cornell@savant.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.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 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@postgres.rocks> wrote:

+Andres Freund 

On Mon, 20 Nov 2023 at 11:36, Evan Cornell <evan.cornell@savant.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

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@postgres.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.cornell@savant.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.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 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@postgres.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

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 <evan.cornell@savant.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.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 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.