ODBC options

From: Brad White <b55white(at)gmail(dot)com>
To: pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: ODBC options
Date: 2023-10-03 21:51:34
Message-ID: CAA_1=92gMbAKwnzinEug7Zs=yOEBd7rB32SrfS8WES2Z4iVjGw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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.

Browse pgsql-odbc by date

  From Date Subject
Next Message 刘庄 2023-10-10 05:09:01 [PATCH] Allow catalogname (database) and procname (no under public schema) enumeration with SQLProcedures
Previous Message Mark Hill 2023-10-02 15:33:31 pg*.dll and *.pdb files in psqlODBC have no version numbers