From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Andy Hartman <hartman60home(at)gmail(dot)com> |
Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Connection Issue |
Date: | 2024-08-02 16:18:52 |
Message-ID: | da213bb5-f9b4-476f-8232-e00feeb8de65@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> 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
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Hartman | 2024-08-02 16:32:19 | Re: Connection Issue |
Previous Message | Vince McMahon | 2024-08-02 15:53:35 | Re: Impact from removal of pgadmin4 |