advanced option set NG when create a PostgreSQL ODBC with windowspowershell

Поиск
Список
Период
Сортировка
От Zeng, Lei
Тема advanced option set NG when create a PostgreSQL ODBC with windowspowershell
Дата
Msg-id BYAPR12MB29670411604C44D7127E2F5D93B60@BYAPR12MB2967.namprd12.prod.outlook.com
обсуждение исходный текст
Ответы Re: advanced option set NG when create a PostgreSQL ODBC with windowspowershell  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
Список 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.

В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Tam, Derek"
Дата:
Сообщение: RE: OpenSSL in ODBC
Следующее
От: "Johnson, Jaya"
Дата:
Сообщение: Issue with the ODBC Drivers.