MIME-Version: 1.0
From: Brad White <b55white@gmail.com>
Date: Tue, 3 Oct 2023 16:51:34 -0500
Message-ID: 
 <CAA_1=92gMbAKwnzinEug7Zs=yOEBd7rB32SrfS8WES2Z4iVjGw@mail.gmail.com>
Subject: ODBC options
To: pgsql-odbc@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000ab5b190606d6e57a"
Archived-At: 
 <https://www.postgresql.org/message-id/CAA_1%3D92gMbAKwnzinEug7Zs%3DyOEBd7rB32SrfS8WES2Z4iVjGw%40mail.gmail.com>
Precedence: bulk

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

I was trying to figure how to set the log directory 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.
So you can set default values in the DSN dialog, or you can set them in the
registry.

-----  ODBCLoggingOn.reg ------
[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\PostgreSQL
Unicode]

"Debug"="1"
"Logdir"="c:\\temp"
------------------------------------------

In the process I documented all the settings and their abbreviations in a
spreadsheet.  I'll post that to the docs mailing list.

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

<div dir=3D"ltr">I was trying to figure how to set the log directory using =
a parameter in the connection string. Short answer is that you can&#39;t.<b=
r><div>But you can using the DSN settings.</div><div>I was under the impres=
sion that going DSN-less and using the parameters=C2=A0on the connection st=
ring, we were free from the effects of the DSN settings.</div><div>That&#39=
;s not true.</div><div>The DSN settings become the default values, overridd=
en by anything in the connection string.</div><div>So you can set default v=
alues in the DSN dialog, or you can set them in the registry.</div><div><br=
></div><div>-----=C2=A0=C2=A0ODBCLoggingOn.reg ------</div><div>[HKEY_LOCAL=
_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\PostgreSQL Unicode]<br><br>=
&quot;Debug&quot;=3D&quot;1&quot;<br>&quot;Logdir&quot;=3D&quot;c:\\temp&qu=
ot;<br></div><div>------------------------------------------</div><div><br>=
</div><div>In the process I documented all the settings and their abbreviat=
ions=C2=A0in a spreadsheet.=C2=A0 I&#39;ll post that to the docs mailing li=
st.</div><div><br></div></div>

--000000000000ab5b190606d6e57a--