public inbox for [email protected]
help / color / mirror / Atom feedFrom: Andy Hartman <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Connection Issue
Date: Fri, 2 Aug 2024 12:32:19 -0400
Message-ID: <CAEZv3cq-md7==pJrKTghg-K3AcXdcxZTUH9ri+pwZO0NtQfSWg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAEZv3cqiwtn+QnPSvjtia1Tr8aVZuGBpmtMEOy-g6+6zVwrS-Q@mail.gmail.com>
<[email protected]>
<CAEZv3crJd3c2iEGsJ21ysv0x53CTz000qua2s1WsxO0uAyf9kw@mail.gmail.com>
<[email protected]>
How can I tell that?
Thanks.
On Fri, Aug 2, 2024 at 12:18 PM Adrian Klaver <[email protected]>
wrote:
>
>
> On 8/2/24 9:00 AM, Andy Hartman wrote:
> Reply to list also.
> Ccing list.
> > I changed to md5 and I can connect via HeideSQL interface no problem
>
> Changed what to md5?
>
> The issue is with Npgsql(?) though.
>
> What is the Npgsql version?
>
> >
> > On Fri, Aug 2, 2024 at 11:05 AM Adrian Klaver <[email protected]
> > <mailto:[email protected]>> wrote:
> >
> > 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] <mailto:[email protected]>
> >
>
> --
> Adrian Klaver
> [email protected]
>
view thread (3+ messages) latest in thread
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: <CAEZv3cq-md7==pJrKTghg-K3AcXdcxZTUH9ri+pwZO0NtQfSWg@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