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 1trctI-006Pwj-1J
	for pgsql-odbc@arkaria.postgresql.org; Mon, 10 Mar 2025 13:09:56 +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 1trctF-00BRJ7-W9
	for pgsql-odbc@arkaria.postgresql.org; Mon, 10 Mar 2025 13:09:54 +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 <davecramer@postgres.rocks>)
	id 1trctF-00BRIy-Of
	for pgsql-odbc@lists.postgresql.org; Mon, 10 Mar 2025 13:09:53 +0000
Received: from pgintl.fastcrypt.com ([149.56.129.164])
	by makus.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <davecramer@postgres.rocks>)
	id 1trctD-00222G-2z
	for pgsql-odbc@postgresql.org;
	Mon, 10 Mar 2025 13:09:52 +0000
Received: from mail-ej1-f47.google.com (mail-ej1-f47.google.com
 [209.85.218.47])
	by pgintl.fastcrypt.com (Postfix) with ESMTPSA id 2750320240
	for <pgsql-odbc@postgresql.org>; Mon, 10 Mar 2025 09:09:51 -0400 (EDT)
Received: by mail-ej1-f47.google.com with SMTP id
 a640c23a62f3a-abbd96bef64so679745866b.3
        for <pgsql-odbc@postgresql.org>; Mon, 10 Mar 2025 06:09:50 -0700 (PDT)
X-Gm-Message-State: AOJu0Ywz2LeQ76W+pAocnPIwmAQajQMd+Lf9JTtfZKEQ4Q6na0ClhhTj
	7YsLmIjyxKx5izF0ghMOgRvwxvZNtVn6i+HPfkFC034va09mkUIf2/wC5yW6vi7h2akW559JMP9
	jr83sjbIgntmS/Os0Y0QPe34ZlcY=
X-Google-Smtp-Source: 
 AGHT+IGC6NaygZR4OgWiZxOg2fpjEOIElB9arnPbv2uPFiCuxG4IE3JT5XVgOdVuaFEOkMU1CPmQ2q80Lz/Rmmq97+k=
X-Received: by 2002:a17:907:3f2a:b0:ac2:9a4:89a8 with SMTP id
 a640c23a62f3a-ac252ed4960mr1556594066b.47.1741612190151; Mon, 10 Mar 2025
 06:09:50 -0700 (PDT)
MIME-Version: 1.0
References: 
 <CANktj40X_DFbLdGuwM3FEsxMpdW+sY1XqUM4fR7wuMp1rzAHLQ@mail.gmail.com>
In-Reply-To: 
 <CANktj40X_DFbLdGuwM3FEsxMpdW+sY1XqUM4fR7wuMp1rzAHLQ@mail.gmail.com>
From: Dave Cramer <davecramer@postgres.rocks>
Date: Mon, 10 Mar 2025 09:09:33 -0400
X-Gmail-Original-Message-ID: 
 <CADK3HHK1s_vy224zUR50-6+GtzT4csDea-dr6EMY86ZFJa52Kg@mail.gmail.com>
X-Gm-Features: AQ5f1JpHKn5dbgOc4di7jDvwBxXk8uBwrasxca_ZOckqZW_q9lFOTdDjt2cPc78
Message-ID: 
 <CADK3HHK1s_vy224zUR50-6+GtzT4csDea-dr6EMY86ZFJa52Kg@mail.gmail.com>
Subject: Re: ODBC Password Encryption - PostgreSQL ANSI(x64)
To: Joseph Fisher <josephpfisher1@gmail.com>
Cc: pgsql-odbc@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000ee4157062ffcaf00"
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/CADK3HHK1s_vy224zUR50-6%2BGtzT4csDea-dr6EMY86ZFJa52Kg%40mail.gmail.com>
Precedence: bulk

--000000000000ee4157062ffcaf00
Content-Type: text/plain; charset="UTF-8"

Please post this to github https://github.com/postgresql-interfaces/psqlodbc
Dave Cramer
www.postgres.rocks


On Mon, 10 Mar 2025 at 08:54, Joseph Fisher <josephpfisher1@gmail.com>
wrote:

> In Windows, please confirm that when using special characters within a
> password string, the password stored is "mangled" when saving the string
> under the ODBC.INI datasource in the registry.
>
> [HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\
>
> So to use a password in a .net app with an OdbcConnection, don't use the
> plain text password, instead use the ODBC.INI datasource saved mangled
> password.
>
> Thank you,
> Joe
>
>
>

--000000000000ee4157062ffcaf00
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div>Please post this to github=C2=A0<a h=
ref=3D"https://github.com/postgresql-interfaces/psqlodbc">https://github.co=
m/postgresql-interfaces/psqlodbc</a></div><div><div dir=3D"ltr" class=3D"gm=
ail_signature"><div dir=3D"ltr">Dave Cramer<div>www.postgres.rocks</div></d=
iv></div></div><br></div></div><br><div class=3D"gmail_quote gmail_quote_co=
ntainer"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, 10 Mar 2025 at 08:54=
, Joseph Fisher &lt;<a href=3D"mailto:josephpfisher1@gmail.com">josephpfish=
er1@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" sty=
le=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);paddi=
ng-left:1ex"><div dir=3D"ltr">
In Windows, please confirm that when using special characters within a=20
password string, the password stored is &quot;mangled&quot; when saving the=
 string
 under the ODBC.INI datasource in the registry.<br><br>[HKEY_CURRENT_USER\S=
oftware\ODBC\ODBC.INI\<br><br><div>So
 to use a password in a .net app with an OdbcConnection, don&#39;t use the=
=20
plain text password, instead use the ODBC.INI datasource saved mangled=20
password. <br></div><div><br></div><div>Thank you,</div><div>Joe</div><div>=
<br></div><div><br></div></div>
</blockquote></div>

--000000000000ee4157062ffcaf00--