public inbox for [email protected]  
help / color / mirror / Atom feed
From: Andy Hartman <[email protected]>
To: [email protected]
Subject: Connection Issue
Date: Fri, 2 Aug 2024 10:56:37 -0400
Message-ID: <CAEZv3cqiwtn+QnPSvjtia1Tr8aVZuGBpmtMEOy-g6+6zVwrS-Q@mail.gmail.com> (raw)

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)"

Any ideas?

Thanks.


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]
  Subject: Re: Connection Issue
  In-Reply-To: <CAEZv3cqiwtn+QnPSvjtia1Tr8aVZuGBpmtMEOy-g6+6zVwrS-Q@mail.gmail.com>

* 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