From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Andy Hartman <hartman60home(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Connection Issue |
Date: | 2024-08-02 15:05:33 |
Message-ID: | e5db1c33-bed0-4a28-8d3b-8814e1ae03c5@aklaver.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 8/2/24 07:56, Andy Hartman wrote:
> I'm using a Powershell script to connect to a remote 16.3(windows)
> version of the DB.
>
> Add-type -path 'C:\Program Files
> (x86)\PostgreSQL\Npgsql\bin\net451\Npgsql.dll'
>
> # Define connection strings for MS SQL and PostgreSQL
> $pgsqlConnectionString =
> "Host=xxxxxx;Port=5432;Username=xxx;Password=xx;Database=xxx;"
>
> # Create connection to PostgreSQL
> $pgsqlConn = New-Object Npgsql.NpgsqlConnection
> $pgsqlConn.ConnectionString = $pgsqlConnectionString
> $pgsqlConn.Open()
>
>
> When this statement hits I get an error:
>
> Exception calling "Open" with "0" argument(s): "Authentication method
> not supported (Received: 10)"
Best bet old library that does not understand scram-sha-256 authentication.
>
> Any ideas?
>
> Thanks.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2024-08-02 15:09:27 | Re: Subscribe to mailing list - General Question |
Previous Message | Andy Hartman | 2024-08-02 14:56:37 | Connection Issue |