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
|
Список | 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
В списке pgsql-odbc по дате отправления: