public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: Andy Hartman <[email protected]>
To: [email protected]
Subject: Re: Connection Issue
Date: Fri, 2 Aug 2024 08:05:33 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAEZv3cqiwtn+QnPSvjtia1Tr8aVZuGBpmtMEOy-g6+6zVwrS-Q@mail.gmail.com>
References: <CAEZv3cqiwtn+QnPSvjtia1Tr8aVZuGBpmtMEOy-g6+6zVwrS-Q@mail.gmail.com>

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
[email protected]

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Connection Issue
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox