public inbox for [email protected]
help / color / mirror / Atom feedFrom: Evan Cornell <[email protected]>
To: Dave Cramer <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: [EXT] ODBC driver on Windows 11 ARM64
Date: Mon, 20 Nov 2023 16:36:47 +0000
Message-ID: <[email protected]> (raw)
In-Reply-To: <CADK3HHLC9u_-52pDOW+k4Cf+zg8t9j_Rz5YT8MS1iFxhJN45cw@mail.gmail.com>
References: <[email protected]>
<CADK3HHJuLzAGL1UTNgzL1NBrcqUqMG3M0gYwH1N0JpfkdRo00g@mail.gmail.com>
<[email protected]>
<CADK3HHLC9u_-52pDOW+k4Cf+zg8t9j_Rz5YT8MS1iFxhJN45cw@mail.gmail.com>
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]
Thanks,
Evan Cornell
Hardware Engineering
C. 419.706.8315
45 Perseverance Way
Hyannis, MA 02601
[email protected]<mailto:[email protected]>
www.savant.com<http://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 9:25 AM, Dave Cramer <[email protected]> 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 <[email protected]<mailto:[email protected]>> 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
[email protected]<mailto:[email protected]>
www.savant.com<http://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 <[email protected]> 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 <[email protected]<mailto:[email protected]>> 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
[email protected]<mailto:[email protected]>
www.savant.com<http://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.
view thread (13+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: [EXT] ODBC driver on Windows 11 ARM64
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox