Re: advanced option set NG when create a PostgreSQL ODBC with windowspowershell
От | Zeng, Lei |
---|---|
Тема | Re: advanced option set NG when create a PostgreSQL ODBC with windowspowershell |
Дата | |
Msg-id | BYAPR12MB296738E99BA72988D2D7C533938C0@BYAPR12MB2967.namprd12.prod.outlook.com обсуждение исходный текст |
Ответ на | advanced option set NG when create a PostgreSQL ODBC with windowspowershell ("Zeng, Lei" <lei11.zeng@nttdata.com>) |
Список | pgsql-odbc |
Hi Hiroshi Inoue
>Where do you find the setting of "Trusted_Connection"?.
>"Trusted_Connection" isn't an option of psqlodbc.
I can follow your question . I did not refer to the setting "Trusted_Connection" in my before messages.
Where did you need it(this setting) ? when you run powershell then some error occur? or some where?
差出人: Inoue, Hiroshi [mailto:h-inoue@dream.email.ne.jp]
送信日時: 2019年9月16日 14:24
宛先: Zeng, Lei
CC: pgsql-odbc@postgresql.org
件名: 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 open the 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 the settings.
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@dream.email.ne.jp]
送信日時: 2019年9月15日 9:04
宛先: Zeng, Lei
CC: pgsql-odbc@postgresql.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.
В списке pgsql-odbc по дате отправления:
Предыдущее
От: "Inoue, Hiroshi"Дата:
Сообщение: Re: advanced option set NG when create a PostgreSQL ODBC with windowspowershell