Thread: Building psqlODBC on newer Visual Studio versions
Hello,
Thanks,
I've been trying to build the driver with newer versions of Visual Studio such as 2017 and 2022 on Windows 10. It's been painful. None of the ps scripts like the newer versions, and many of the mak files expect to be used only with version 9.6. I managed to build the x86 dlls with nmake on 2022, but now I'm fighting with a lot of stuff to get the installer to build (changing the version number to 09.06.0100, setting WIX, hacking NoPDB... ).
Just wondering whether this project is still the official open source PostgreSQL ODBC driver, or is there a newer fork I should be looking at instead.
Thanks,
Paul
Hello,
I have managed to get the current package to build using Visual Studio 2022 using the batch files from a VS command prompt.
The most significant changes I had to make were to MSProgram-Get.ps1. I had to add a toolsout of 17 for VS version 17.6, and I had to add a module import for VSSetup in find_vs_installation.
For building installers to work, I had to set an explicit value of WIX to the parent of the Wix bin directory.
Cheers,
Paul Chambre
Paul Chambre
On Wed, May 8, 2024 at 1:17 PM Paul Chambre <pchambre@deephaven.io> wrote:
Hello,I've been trying to build the driver with newer versions of Visual Studio such as 2017 and 2022 on Windows 10. It's been painful. None of the ps scripts like the newer versions, and many of the mak files expect to be used only with version 9.6. I managed to build the x86 dlls with nmake on 2022, but now I'm fighting with a lot of stuff to get the installer to build (changing the version number to 09.06.0100, setting WIX, hacking NoPDB... ).Just wondering whether this project is still the official open source PostgreSQL ODBC driver, or is there a newer fork I should be looking at instead.
Thanks,Paul
Paul Chambre
Senior Solutions Architect
+1-719-465-6097
+33 (0)6.48.85.52.12
Hi Paul,
On Thu, 9 May 2024 at 05:42, Paul Chambre <pchambre@deephaven.io> wrote:
Hello,I have managed to get the current package to build using Visual Studio 2022 using the batch files from a VS command prompt.The most significant changes I had to make were to MSProgram-Get.ps1. I had to add a toolsout of 17 for VS version 17.6, and I had to add a module import for VSSetup in find_vs_installation.For building installers to work, I had to set an explicit value of WIX to the parent of the Wix bin directory.Cheers,
Paul ChambreOn Wed, May 8, 2024 at 1:17 PM Paul Chambre <pchambre@deephaven.io> wrote:Hello,I've been trying to build the driver with newer versions of Visual Studio such as 2017 and 2022 on Windows 10. It's been painful. None of the ps scripts like the newer versions, and many of the mak files expect to be used only with version 9.6. I managed to build the x86 dlls with nmake on 2022, but now I'm fighting with a lot of stuff to get the installer to build (changing the version number to 09.06.0100, setting WIX, hacking NoPDB... ).Just wondering whether this project is still the official open source PostgreSQL ODBC driver, or is there a newer fork I should be looking at instead.
Thanks,Paul--Paul ChambreSenior Solutions Architect+1-719-465-6097+33 (0)6.48.85.52.12
Hi Dave,
Looking at the new repo, it looks like it might work with VS 2017, but would still fail with 2022. I'll try to make a pass at this set in the next few days. OK if I submit a PR with needed changes?
Also, would it be possible for you to update this page (https://odbc.postgresql.org/) to point to the github home?
Thanks,
Paul
On Thu, May 9, 2024 at 1:02 PM Dave Cramer <davecramer@postgres.rocks> wrote:
Hi Paul,On Thu, 9 May 2024 at 05:42, Paul Chambre <pchambre@deephaven.io> wrote:Hello,I have managed to get the current package to build using Visual Studio 2022 using the batch files from a VS command prompt.The most significant changes I had to make were to MSProgram-Get.ps1. I had to add a toolsout of 17 for VS version 17.6, and I had to add a module import for VSSetup in find_vs_installation.For building installers to work, I had to set an explicit value of WIX to the parent of the Wix bin directory.Cheers,
Paul ChambreOn Wed, May 8, 2024 at 1:17 PM Paul Chambre <pchambre@deephaven.io> wrote:Hello,I've been trying to build the driver with newer versions of Visual Studio such as 2017 and 2022 on Windows 10. It's been painful. None of the ps scripts like the newer versions, and many of the mak files expect to be used only with version 9.6. I managed to build the x86 dlls with nmake on 2022, but now I'm fighting with a lot of stuff to get the installer to build (changing the version number to 09.06.0100, setting WIX, hacking NoPDB... ).Just wondering whether this project is still the official open source PostgreSQL ODBC driver, or is there a newer fork I should be looking at instead.
Thanks,Paul--Paul ChambreSenior Solutions Architect+1-719-465-6097+33 (0)6.48.85.52.12
Paul Chambre
Senior Solutions Architect
+1-719-465-6097
+33 (0)6.48.85.52.12
Paul,
Pretty sure we are building with 2022 in the github actions
We are using windows-latest which should be runner-images/images/windows/Windows2022-Readme.md at main · actions/runner-images (github.com)
Yes, I can put a link to the new repo.
Thanks!
Dave Cramer
www.postgres.rocks
On Thu, 9 May 2024 at 08:06, Paul Chambre <pchambre@deephaven.io> wrote:
Hi Dave,Looking at the new repo, it looks like it might work with VS 2017, but would still fail with 2022. I'll try to make a pass at this set in the next few days. OK if I submit a PR with needed changes?Also, would it be possible for you to update this page (https://odbc.postgresql.org/) to point to the github home?Thanks,PaulOn Thu, May 9, 2024 at 1:02 PM Dave Cramer <davecramer@postgres.rocks> wrote:Hi Paul,On Thu, 9 May 2024 at 05:42, Paul Chambre <pchambre@deephaven.io> wrote:Hello,I have managed to get the current package to build using Visual Studio 2022 using the batch files from a VS command prompt.The most significant changes I had to make were to MSProgram-Get.ps1. I had to add a toolsout of 17 for VS version 17.6, and I had to add a module import for VSSetup in find_vs_installation.For building installers to work, I had to set an explicit value of WIX to the parent of the Wix bin directory.Cheers,
Paul ChambreOn Wed, May 8, 2024 at 1:17 PM Paul Chambre <pchambre@deephaven.io> wrote:Hello,I've been trying to build the driver with newer versions of Visual Studio such as 2017 and 2022 on Windows 10. It's been painful. None of the ps scripts like the newer versions, and many of the mak files expect to be used only with version 9.6. I managed to build the x86 dlls with nmake on 2022, but now I'm fighting with a lot of stuff to get the installer to build (changing the version number to 09.06.0100, setting WIX, hacking NoPDB... ).Just wondering whether this project is still the official open source PostgreSQL ODBC driver, or is there a newer fork I should be looking at instead.
Thanks,Paul--Paul ChambreSenior Solutions Architect+1-719-465-6097+33 (0)6.48.85.52.12--Paul ChambreSenior Solutions Architect+1-719-465-6097+33 (0)6.48.85.52.12