Re: Building psqlODBC on newer Visual Studio versions

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,

See postgresql-interfaces/psqlodbc (github.com)

I've moved the project to github.

Dave Cramer

www.postgres.rocks

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

--

Paul Chambre

Senior Solutions Architect

+1-719-465-6097

+33 (0)6.48.85.52.12