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

Hi,

On 2019/09/10 14:07, Zeng, Lei wrote:
>
> 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.

---
このメールは、AVG によってウイルス チェックされています。
http://www.avg.com