Re: Building psqlODBC on newer Visual Studio versions

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)
<https://github.com/actions/runner-images/blob/main/images/windows/Windows2022-Readme.md>

<https://github.com/actions/runner-images/blob/main/images/windows/Windows2022-Readme.md>That
said please submit a PR if you find that it doesn't build.

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(at)deephaven(dot)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,
> Paul
>
> On Thu, May 9, 2024 at 1:02 PM Dave Cramer <davecramer(at)postgres(dot)rocks>
> wrote:
>
>> Hi Paul,
>>
>> See postgresql-interfaces/psqlodbc (github.com)
>> <https://github.com/postgresql-interfaces/psqlodbc>
>>
>> <https://github.com/postgresql-interfaces/psqlodbc>I've moved the
>> project to github.
>> Dave Cramer
>> www.postgres.rocks
>>
>>
>> On Thu, 9 May 2024 at 05:42, Paul Chambre <pchambre(at)deephaven(dot)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(at)deephaven(dot)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
>
>