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.
Thanks,
Brad.