Date: Fri, 6 Oct 2023 15:30:43 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Brad White <b55white@gmail.com>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: ODBC options
Message-ID: <ZSBgYzT3vh7YOsew@momjian.us>
References: 
 <CAA_1=909ZR0ofmS5_JKonYwf+AdrU4_wojm5ckaB50s2EibzpQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAA_1=909ZR0ofmS5_JKonYwf+AdrU4_wojm5ckaB50s2EibzpQ@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/ZSBgYzT3vh7YOsew%40momjian.us>
Precedence: bulk

On Tue, Oct  3, 2023 at 05:34:01PM -0500, Brad White wrote:
>   I was trying to figure how to set the log directory on my Windows client
> using a parameter in the connection string. Short answer is that you can't.
> But you can using the DSN settings.
> I was under the impression that going DSN-less and using the parameters on the
> connection string, we were free from the effects of the DSN settings.
> That's not true.
> The DSN settings become the default values, overridden by anything in the
> connection string.
> Conversely, there are two settings which, for reasons that escape me, can't be
> set via the connection string.
> In the process, I found the documentation on the ODBC settings to be scattered
> and inconsistent, so I documented all the settings and their abbreviations in a
> spreadsheet.  Is there a useful place or format where I can post that?
> 
> Spreadsheet is here if anyone wants to look at it.
> https://www.dropbox.com/scl/fi/v1uj1umtj20k1ljenodvy/
> psqlODBC-Configuration-Options.xlsx?rlkey=fit9kbgy0fv0fr9vt0u0a9oim&dl=0

Please see:

	https://odbc.postgresql.org/faq.html#1.6

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.