Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-odbc-owner+archive@lists.postgresql.org>)
	id 1rqYcU-00D5AB-Iq
	for pgsql-odbc@arkaria.postgresql.org; Sat, 30 Mar 2024 13:19:39 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-odbc-owner+archive@lists.postgresql.org>)
	id 1rqYcT-008YU7-Lv
	for pgsql-odbc@arkaria.postgresql.org; Sat, 30 Mar 2024 13:19:37 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <cladisch@fastmail.net>)
	id 1rqAyP-00Haio-68
	for pgsql-odbc@lists.postgresql.org; Fri, 29 Mar 2024 12:04:42 +0000
Received: from fout7-smtp.messagingengine.com ([103.168.172.150])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <cladisch@fastmail.net>)
	id 1rqAyK-0072wz-L6
	for pgsql-odbc@postgresql.org; Fri, 29 Mar 2024 12:04:39 +0000
Received: from compute5.internal (compute5.nyi.internal [10.202.2.45])
	by mailfout.nyi.internal (Postfix) with ESMTP id 5F43813800FB
	for <pgsql-odbc@postgresql.org>; Fri, 29 Mar 2024 08:04:36 -0400 (EDT)
Received: from imap42 ([10.202.2.92])
  by compute5.internal (MEProxy); Fri, 29 Mar 2024 08:04:36 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fastmail.net; h=
	cc:content-type:content-type:date:date:from:from:in-reply-to
	:in-reply-to:message-id:mime-version:references:reply-to:subject
	:subject:to:to; s=fm2; t=1711713876; x=1711800276; bh=kGywiTLwac
	M23bF2KNYbuUVuRyAZ4Ud2ySq/IcvBTGI=; b=f5zaYTvOEWzIvm4wNNTXgmPTGR
	IPUNvfpt8FIU40ZEteE1DEvoZBmXCh4JveID/TIO/Gsdn6SzDCkgdLPoMlTvfjp7
	m8zzzSEgLlqaYINgvj1id1mu1eKO7WgfZMmDDnrsZBBaicZebzYTwCTXQo+IajVb
	p8uW1zOvHfb8aQRykMpVj7fg3PntJwYqkqV2VYxZOOu29+ZIKXeYsAsheKDQTRN4
	Gp9/8o8BdJhX7IKForbrTS62sr235LM5s92Q3Qdd1ZjLZ9CVTOenJYMSjm6dY/Sv
	ptB5JqLqIeaKm6hvJ/CNQrtwux3gjBUeeYg6GwIUXCKX9ZZj0Zv2yx2AuyAg==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:content-type:content-type:date:date
	:feedback-id:feedback-id:from:from:in-reply-to:in-reply-to
	:message-id:mime-version:references:reply-to:subject:subject:to
	:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=
	fm2; t=1711713876; x=1711800276; bh=kGywiTLwacM23bF2KNYbuUVuRyAZ
	4Ud2ySq/IcvBTGI=; b=MOtZ4byE1HPs5i55TTRbttn/ZR9pucrL01Fc9BlxCoCu
	hTxZ6wSYE57KS3dWvZC5VrJyKkrRwKI4AQ6RAfZzfjdIf9tAdaBRGGUEPyK1z2vx
	X4hmFQ65AJNngN2n6P7CCqG8Rehp4d71Vi5bGU8/+mhemLjpip30EEHkG7DTlPDm
	ljrNQajaBnKHJXN/MihqHXQiIVfBPKGSUfbOezr9FYP2Yh+IRMzmu5tPifa8o2Wm
	fUxZi8Ekamzy8lrBEAPFT4J9q0T+HU7Ulf1nLpKWAkFTJPZ6KWNW2YUyG46FnEZS
	gxiB7l86iZDLqyNMVrmRMW2dbJRBN9ZLQ27Ip+OCpw==
X-ME-Sender: <xms:U64GZl1R-G82IfvCBI3lqQ0zchDNdLNkOYsbgZJ7lRNl16NTopveUA>
    <xme:U64GZsFOhrVI22jYq6Q9z3yHtK3hYunJdz3JmBHzXrM5MBX8Sgfd3WfhGyH9zRDIf
    l9ogLJkCgOwrw>
X-ME-Proxy-Cause: 
 gggruggvucftvghtrhhoucdtuddrgedvledruddvvddgfeejucetufdoteggodetrfdotf
    fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen
    uceurghilhhouhhtmecufedttdenucenucfjughrpefofgggkfgjfhffhffvufgtsehttd
    ertderredtnecuhfhrohhmpedfvehlvghmvghnshcunfgrughishgthhdfuceotghlrggu
    ihhstghhsehfrghsthhmrghilhdrnhgvtheqnecuggftrfgrthhtvghrnhepueefleeugf
    ejfeefieelheevteeiudffhffhkeeifeeugfeuheevfeefgeekhffhnecuvehluhhsthgv
    rhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheptghlrgguihhstghhsehfrg
    hsthhmrghilhdrnhgvth
X-ME-Proxy: <xmx:VK4GZl5GPeTYAbdP4OofccXDZLkfkfIhD9w6c-n8XDJHXHhFAD2AHQ>
    <xmx:VK4GZi3W2uKxEu_CauZf3m0e198ahtVv1pLfxNMW11r7jZ8_LSbjRA>
    <xmx:VK4GZoFjWechQ5s_YjnDo6RtS51EHeTQpvGMbKerRKUcpW-_wHYK6g>
    <xmx:VK4GZj_gR-oXEdp8AVmHnYMExemVPz0sOT45S8ZUE14byyfHD7KsBg>
    <xmx:VK4GZiOaEywuf4uLcFgJ4QWTjpIjun2EzlrTEKM-oQhFH3q8bRdFig>
Feedback-ID: i008541b6:Fastmail
Received: by mailuser.nyi.internal (Postfix, from userid 501)
	id E5AF7BC007D; Fri, 29 Mar 2024 08:04:35 -0400 (EDT)
X-Mailer: MessagingEngine.com Webmail Interface
User-Agent: Cyrus-JMAP/3.11.0-alpha0-333-gbfea15422e-fm-20240327.001-gbfea1542
MIME-Version: 1.0
Message-Id: <31e17635-3716-4ffd-8a47-b5dc92112f09@app.fastmail.com>
In-Reply-To: 
 <CADK3HH+nrL9S7vLfM0ExQ4Wq-nPZhS1mSSv6m6V38wJUceaE4A@mail.gmail.com>
References: 
 <CADK3HH+nrL9S7vLfM0ExQ4Wq-nPZhS1mSSv6m6V38wJUceaE4A@mail.gmail.com>
Date: Fri, 29 Mar 2024 13:03:52 +0100
From: "Clemens Ladisch" <cladisch@fastmail.net>
To: "PostgreSQL mailing lists" <pgsql-odbc@postgresql.org>
Subject: Re: How to create an ODBC datasource in CI
Content-Type: text/plain
List-Id: <pgsql-odbc.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-odbc@lists.postgresql.org>
List-Owner: <mailto:pgsql-odbc-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-odbc>
Archived-At: 
 <https://www.postgresql.org/message-id/31e17635-3716-4ffd-8a47-b5dc92112f09%40app.fastmail.com>
Precedence: bulk

Dave Cramer wrote:
> 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.

The ODBC Administrator tool just calls SQLConfigDataSource. You could write your own tool to do this, or add the registry entries directly in HKCU\Software\ODBC\ODBC.INI\ODBC Data Sources.


Best regards,
Clemens