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 ) id 1trceU-006MUS-5B for pgsql-odbc@arkaria.postgresql.org; Mon, 10 Mar 2025 12:54:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1trceS-00BCYI-1K for pgsql-odbc@arkaria.postgresql.org; Mon, 10 Mar 2025 12:54:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tqZgV-008b2i-QD for pgsql-odbc@lists.postgresql.org; Fri, 07 Mar 2025 15:32:23 +0000 Received: from mail-yw1-x112c.google.com ([2607:f8b0:4864:20::112c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tqZgS-001WIR-0v for pgsql-odbc@postgresql.org; Fri, 07 Mar 2025 15:32:23 +0000 Received: by mail-yw1-x112c.google.com with SMTP id 00721157ae682-6f9625c0fccso19386747b3.1 for ; Fri, 07 Mar 2025 07:32:21 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1741361540; x=1741966340; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=DJSmgT6NFZVAWNWXzMsQpdp52I+wKkqK4iwkVADKIII=; b=F9fpEUE407Dc+/HVz5uruLGKeinNO2dDyezSN/q/JHQPEWNsKQzF3KnGPQrci383Tx HMuMGW7DIAsCwJpzVWfOAfTPBq2haI329QSqbwDbYZl81/sVEA9pf1rqwUo5sVS0NB7G x3jitRvjJjrNN6gsK1wJoFaMHYmV7aLEl9wXGsLEoA2mYUxtZNL81aSportslTidURth 5w5y+r//3EYj0P8J7IJgEgKJCaJWQ1NFtrcxEQBTDwW1vd9CGLwqOdd/fhx1zFAGOiLy HQG5P8tlTRO6DlOjCXHR0fZS0eQZ39Fl5RggQizfTceYb1mPnbomJFYwbpr0XuMdi9DL gPTg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741361540; x=1741966340; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=DJSmgT6NFZVAWNWXzMsQpdp52I+wKkqK4iwkVADKIII=; b=pln27EesP8OCfXugLM78QM4pELoIiPKMksrY9a3IUdHiM7xP+VRq6vrT7pioK0lGjb 4j9PA7W1RbMcT5/YlXwaUwZLeN6QRvcLc/ei4zA2iFbukVtXpCeqvy9vMpPyCymlRvGQ Mcjtkh6G/VbKRUqCkSO3bkrsbehGFjbdtMZBFa/zuqNA+jP6Wc1ujES9TeML5qgA2d52 TPW4a6QGOQrGjDrASjmNBN6E3QHg8H0eaAe8m/XQ306hNOG11nDdIslrW6nCT00/goWK aWC3HLP27hxKB+OXXdpXnDJ++fePY7aw3MlKmsd4DtqS+au5QaUTK0r1jwI1x5pl1R/v m/rA== X-Gm-Message-State: AOJu0YxCDi3rxClnXRuWmYSJ/Ch3nXnFBPV7xTtl51fzXQT0caIm2yDa FqopUw6fn8i+yTJhkxxKU5TzJo/gD2NkTzw6Ww0bBlrs2NIKYbeDDwbJzTFg4tdH/eoEVrj0l3F oTAjAzuZubUxaBqsI+V7OpPzAjsYeVFi0 X-Gm-Gg: ASbGncsVeDYOo7RkSN2v6z4rG6vAgDK4FDsZpUwggcKl2D0EEdJtwFDXn1kJFW0k3lX j91vf7raNvyGwPaEeaY4zmAkBu6o6GFFaWQGWC1HBtJyzKVotB15bSm0/xDJvb2Q6Cnpc1wLp7x pq96cncPHmmggIimxW54R82c1hdA== X-Google-Smtp-Source: AGHT+IGYEjgBuNba284CNS6a3IhJmFLYbYncudGbZsFr4U4ZGu5mcNWLUnO5ktO5iheWTIMZg3Bm82EI+vApsA+C93c= X-Received: by 2002:a05:690c:6e0c:b0:6f9:a3c6:b2e4 with SMTP id 00721157ae682-6febf3b499dmr52713807b3.37.1741361538276; Fri, 07 Mar 2025 07:32:18 -0800 (PST) MIME-Version: 1.0 From: Joseph Fisher Date: Fri, 7 Mar 2025 10:32:06 -0500 X-Gm-Features: AQ5f1Jp0DMeVUweUbJjWw8onLNsVWDHJh2hdDMhlYaLzKCICRpJFhcHDJ0evN2I Message-ID: Subject: ODBC Password Encryption - PostgreSQL ANSI(x64) To: pgsql-odbc@postgresql.org Content-Type: multipart/alternative; boundary="000000000000ea24a6062fc253dc" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ea24a6062fc253dc Content-Type: text/plain; charset="UTF-8" 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 --000000000000ea24a6062fc253dc Content-Type: text/html; charset="UTF-8"
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


--000000000000ea24a6062fc253dc--