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

On 2019/09/16 10:54, Zeng, Lei wrote:
>
> 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 openthe 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 thesettings.
>
> config [MaxVarcharSize=200] is the optional level  you can find it at
> the 「data source」panel
>

Where do you find the setting of  "Trusted_Connection"?.
"Trusted_Connection" isn't an option of psqlodbc.

regards,
Hiroshi Inoue

> *差出人:*Inoue, Hiroshi [mailto:h-inoue(at)dream(dot)email(dot)ne(dot)jp]
> *送信日時:*2019年9月15日9:04
> *宛先:*Zeng, Lei
> *ＣＣ:*pgsql-odbc(at)postgresql(dot)org
> *件名:*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.
>
> 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