From: Bruce Momjian <bruce@momjian.us>
To: Brad White <b55white@gmail.com>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: ODBC options
Date: Fri, 6 Oct 2023 15:30:43 -0400
Message-ID: <ZSBgYzT3vh7YOsew@momjian.us> (raw)
In-Reply-To: <CAA_1=909ZR0ofmS5_JKonYwf+AdrU4_wojm5ckaB50s2EibzpQ@mail.gmail.com>
References: <CAA_1=909ZR0ofmS5_JKonYwf+AdrU4_wojm5ckaB50s2EibzpQ@mail.gmail.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: bruce@momjian.us, b55white@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: ODBC options
In-Reply-To: <ZSBgYzT3vh7YOsew@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox