Postgres Pro
Downloads
Home   >   mailing lists

Thread: Registering DSN with odbcconf.exe overwrites the connectionattributes with defaults

Registering DSN with odbcconf.exe overwrites the connectionattributes with defaults

From
Haribabu Kommi
Date:
With the following command, the SSLmode of the DSN is defaults to disable, even the "prefer" option is provided in the connection attributes.

odbcconf.exe /A {CONFIGDSN "PostgreSQL Unicode(x64)" "DSN=test3|SSLmode=prefer"}

During the configDSN, first the connection attributes are parsed in ParseAttributes function and later all the values are replaced with defaults using getCiAllDefaults. Because of this reason, all the provided connection options are ignored.

By changing it as first fill the ci with defaults and later update it with connection attributes works fine with connection attributes. Patch attached. Am I missing anything?

Regards,
Hari Babu
Fujitsu Australia
Attachment

Re: Registering DSN with odbcconf.exe overwrites the connectionattributes with defaults

From
"Inoue, Hiroshi"
Date:
Hi,

On 2018/04/23 18:25, Haribabu Kommi wrote:
With the following command, the SSLmode of the DSN is defaults to disable, even the "prefer" option is provided in the connection attributes.

odbcconf.exe /A {CONFIGDSN "PostgreSQL Unicode(x64)" "DSN=test3|SSLmode=prefer"}

During the configDSN, first the connection attributes are parsed in ParseAttributes function and later all the values are replaced with defaults using getCiAllDefaults. Because of this reason, all the provided connection options are ignored.

Thanks for the report.
I would take care of this issue.

regards,
Hiroshi Inoue


By changing it as first fill the ci with defaults and later update it with connection attributes works fine with connection attributes. Patch attached. Am I missing anything?

Regards,
Hari Babu
Fujitsu Australia

Re: Registering DSN with odbcconf.exe overwrites the connectionattributes with defaults

From
"Inoue, Hiroshi"
Date:
Sorry for the late reply,

Could you please try the test drivers 10.02.0200 on Windows at
    https://winpg.jp/~inoue/psqlodbc/index.html
?

regards,
Hiroshi Inoue

On 2018/04/24 15:06, Inoue, Hiroshi wrote:
Hi,

On 2018/04/23 18:25, Haribabu Kommi wrote:
With the following command, the SSLmode of the DSN is defaults to disable, even the "prefer" option is provided in the connection attributes.

odbcconf.exe /A {CONFIGDSN "PostgreSQL Unicode(x64)" "DSN=test3|SSLmode=prefer"}

During the configDSN, first the connection attributes are parsed in ParseAttributes function and later all the values are replaced with defaults using getCiAllDefaults. Because of this reason, all the provided connection options are ignored.

Thanks for the report.
I would take care of this issue.

regards,
Hiroshi Inoue


By changing it as first fill the ci with defaults and later update it with connection attributes works fine with connection attributes. Patch attached. Am I missing anything?

Regards,
Hari Babu
Fujitsu Australia

Re: Registering DSN with odbcconf.exe overwrites the connectionattributes with defaults

From
Haribabu Kommi
Date:

On Sat, Apr 28, 2018 at 3:22 PM, Inoue, Hiroshi <h-inoue@dream.email.ne.jp> wrote:
Sorry for the late reply,

Could you please try the test drivers 10.02.0200 on Windows at
    https://winpg.jp/~inoue/psqlodbc/index.html
?

Thanks for sharing the latest driver and the issue is fixed.
I am able to create the DSN with provided values instead of defaults.

Regards,
Hari Babu
Fujitsu Australia