Обсуждение: Registering DSN with odbcconf.exe overwrites the connectionattributes with defaults

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

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