public inbox for [email protected]
help / color / mirror / Atom feedFrom: Dave Cramer <[email protected]>
To: Jon Raiford <[email protected]>
Cc: PostgreSQL mailing lists <[email protected]>
Subject: Re: How to create an ODBC datasource in CI
Date: Fri, 29 Mar 2024 11:11:54 -0400
Message-ID: <CADK3HHKG-yvTBAYP30vfpzjrt66BtVpMx1UDHv4PpQ6DPY-5ng@mail.gmail.com> (raw)
In-Reply-To: <SA1PR17MB53505317C9E02F989A9D455FBE3A2@SA1PR17MB5350.namprd17.prod.outlook.com>
References: <CADK3HH+nrL9S7vLfM0ExQ4Wq-nPZhS1mSSv6m6V38wJUceaE4A@mail.gmail.com>
<SA1PR17MB53505317C9E02F989A9D455FBE3A2@SA1PR17MB5350.namprd17.prod.outlook.com>
On Fri, 29 Mar 2024 at 08:41, Jon Raiford <[email protected]> wrote:
> I’m not familiar with GitHub Actions, but I know you can create data
> sources from the command line. This is all stored in the registry, which
> you can update using the reg command.
>
>
>
>
> https://learn.microsoft.com/en-us/windows-server/administration/windows-commands/reg
>
>
>
> The easiest thing to do may be to create a data source manually and export
> it into a .reg file. You can then either import the data source using the
> reg file or just use it as a template to add the entries as you like.
>
>
> Just run Regedit and locate the data source you would like to export.
>
>
>
> 64-bit System Data Sources: \\HKLM\SOFTWARE\ODBC\
> <http:///HKLM/SOFTWARE/ODBC/;
>
> 32-bit System Data Sources: \\HKLM\SOFTWARE\WOW6432Node\ODBC\
> <http:///HKLM/SOFTWARE/WOW6432Node/ODBC/;
>
> 64-bit User Data Sources: \\HKCU\SOFTWARE\ODBC\
>
> 32-bit User Data Sources: \\HKCU\SOFTWARE\ODBC\
> <http:///HKCU/SOFTWARE/ODBC/; <- This is mixed in with the 64-bit
> entries and the driver referenced determines if 32/64
>
>
>
> Drivers are defined under the system keys under the section ODBCINST.INI.
> Data sources are defined under the section ODBC.INI, both as a folder
> containing the details of the data source as well as an entry under
> “ODBC.INI\ODBC Data Sources”, which associates the data source with the
> driver to use with it.
>
>
>
> I think if you view these entries in Regedit you will see the
> relationships between everything. It may help to create a data source for
> each type.
>
>
>
> The above describes how to create a static ODBC data source. Alternatively
> you can use a file DSN or simply make a connection string from your test
> case and avoid the data source completely. Although I suppose you may want
> to do each in order to test each possibility.
>
>
>
> Let me know if you have any questions or need assistance.
>
>
>
> Jon
>
Hey Jon,
Thanks, that will help immensely.
It's been a while since I've done anything with Windows.
Dave
>
>
>
>
> *From: *Dave Cramer <[email protected]>
> *Date: *Friday, March 29, 2024 at 7:25 AM
> *To: *PostgreSQL mailing lists <[email protected]>
> *Subject: *How to create an ODBC datasource in CI
>
> Greetings,
>
>
>
> In order to test the driver using github actions we need to be able to
> create a windows datasource. Usually this requires some kind of user
> interaction.
>
>
>
> Has anyone done this on GH actions ?
>
>
>
>
> Dave Cramer
>
view thread (10+ 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: How to create an ODBC datasource in CI
In-Reply-To: <CADK3HHKG-yvTBAYP30vfpzjrt66BtVpMx1UDHv4PpQ6DPY-5ng@mail.gmail.com>
* 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