Re: How to create an ODBC datasource in CI

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 <davecramer(at)gmail(dot)com>
Date: Friday, March 29, 2024 at 7:25 AM
To: PostgreSQL mailing lists <pgsql-odbc(at)postgresql(dot)org>
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