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

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

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

Zeng, Lei

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.
Reply | Threaded
Open this post in threaded view
|

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

Inoue, Hiroshi-2
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.

ウイルス フリー。 www.avg.com
Reply | Threaded
Open this post in threaded view
|

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

Zeng, Lei
In reply to this post by Zeng, Lei

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

inputODBCand 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 sourcepanel

 

差出人: Inoue, Hiroshi [mailto:[hidden email]]
送信日時: 2019915 9:04
宛先: Zeng, Lei
CC: [hidden email]
件名: 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.

 

ウイルス フリー。 www.avg.com

 

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.
Reply | Threaded
Open this post in threaded view
|

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

Inoue, Hiroshi-2


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

inputODBCand 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 sourcepanel


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

regards,
Hiroshi Inoue

 

差出人: Inoue, Hiroshi [[hidden email]]
送信日時: 2019915 9:04
宛先: Zeng, Lei
CC: [hidden email]
件名: 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 のロゴ

このメールは、AVG アンチウイルス ソフトウェアでウイルス チェックされています。
www.avg.com


Reply | Threaded
Open this post in threaded view
|

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

Zeng, Lei
In reply to this post by Zeng, Lei

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:[hidden email]]
送信日時: 2019916 14:24
宛先: Zeng, Lei
CC: [hidden email]
件名: 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

inputODBCand 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 sourcepanel


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

regards,
Hiroshi Inoue


 

差出人: Inoue, Hiroshi [[hidden email]]
送信日時: 2019915 9:04
宛先: Zeng, Lei
CC: [hidden email]
件名: 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 のロゴ

このメールは、AVG アンチウイルス ソフトウェアでウイルス チェックされています。
www.avg.com



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.