From: | "Zeng, Lei" <lei11(dot)zeng(at)nttdata(dot)com> |
---|---|
To: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Cc: | "Zeng, Lei" <lei11(dot)zeng(at)nttdata(dot)com> |
Subject: | advanced option set NG when create a PostgreSQL ODBC with windows powershell |
Date: | 2019-09-10 05:07:51 |
Message-ID: | BYAPR12MB29670411604C44D7127E2F5D93B60@BYAPR12MB2967.namprd12.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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.
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Johnson, Jaya | 2019-09-10 21:27:07 | Issue with the ODBC Drivers. |
Previous Message | Tam, Derek | 2019-08-26 22:55:58 | RE: OpenSSL in ODBC |