Re: advanced option set NG when create a PostgreSQL ODBC with windowspowershell

Hi Hiroshi Inoue

Thanks to regard my message.

>How did you confirm the setting?

　After run ten PowerShelll cmdlet do like this:

  → 「Windows10 app　search ※　the button next to the windows btn at the left-bottom of the windows desktop」

→ input「ODBC」and search

→ then you can open the os ODBC settings panel

→ click 「system DNS」 tab

 → you can find that odbc name that added by PowerShelll

→  double click the name then you can confirm the settings.

       config [MaxVarcharSize=200] is the optional level  you can find it at the 「data source」panel

Hi,

Hi

 

My OS is windows10 64bit

When I try to create a PostgreSQL ODBC with powershell

 

Actions :

1. install PostgreSQL ODBC

2. Run powershell  with admin role

3. Run

Add-OdbcDsn PostgreSQLWithPowerShell -DriverName "PostgreSQL Unicode(x64)" -DsnType System -SetPropertyValue @("Server=localhost", "Trusted_Connection=Yes", "Database=appdb", "Port=5432", "UserName=test", "Password=test", "MaxVarcharSize=200")

 

Result:

1.PostgreSQLWithPowerShell  was created successfully.

2.The config "Server=localhost", "Trusted_Connection=Yes", "Database=appdb", "Port=5432", "UserName=test", "Password=test" was setted successfully.

How did you confirm the setting?

regards,
Hiroshi Inoue

3.But the advanced option config "MaxVarcharSize=200" was not work.

※see https://odbc.postgresql.org/docs/config-opt.html

Question:

how can the config [MaxVarcharSize=200] work with powershell ? thanks

Disclaimer: This email and any attachments are sent in strictest confidence for the sole use of the addressee and may contain legally privileged, confidential, and proprietary data. If you are not the intended recipient, please advise the sender by replying promptly to this email and then delete and destroy this email and any attachments without any further use, copying or forwarding.