public inbox for [email protected]  

help / color / mirror / Atom feed

From: Jon Raiford <[email protected]>
To: Dave Cramer <[email protected]>
To: PostgreSQL mailing lists <[email protected]>
Subject: Re: How to create an ODBC datasource in CI
Date: Fri, 29 Mar 2024 12:41:08 +0000
Message-ID: <SA1PR17MB53505317C9E02F989A9D455FBE3A2@SA1PR17MB5350.namprd17.prod.outlook.com> (raw)
In-Reply-To: <CADK3HH+nrL9S7vLfM0ExQ4Wq-nPZhS1mSSv6m6V38wJUceaE4A@mail.gmail.com>
References: <CADK3HH+nrL9S7vLfM0ExQ4Wq-nPZhS1mSSv6m6V38wJUceaE4A@mail.gmail.com>

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\</HKLM/SOFTWARE/ODBC/>
32-bit System Data Sources: \\HKLM\SOFTWARE\WOW6432Node\ODBC\</HKLM/SOFTWARE/WOW6432Node/ODBC/>
64-bit User Data Sources: \\HKCU\SOFTWARE\ODBC\
32-bit User Data Sources: \\HKCU\SOFTWARE\ODBC\</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


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: <SA1PR17MB53505317C9E02F989A9D455FBE3A2@SA1PR17MB5350.namprd17.prod.outlook.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