Feedback-ID: i76984098:Fastmail
Message-ID: <45197a47-fadd-4588-9042-8a22da5f9148@aklaver.com>
Date: Fri, 2 Aug 2024 09:44:07 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Connection Issue
To: Andy Hartman <hartman60home@gmail.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <CAEZv3cqiwtn+QnPSvjtia1Tr8aVZuGBpmtMEOy-g6+6zVwrS-Q@mail.gmail.com>
 <e5db1c33-bed0-4a28-8d3b-8814e1ae03c5@aklaver.com>
 <CAEZv3crJd3c2iEGsJ21ysv0x53CTz000qua2s1WsxO0uAyf9kw@mail.gmail.com>
 <da213bb5-f9b4-476f-8232-e00feeb8de65@aklaver.com>
 <CAEZv3cq-md7==pJrKTghg-K3AcXdcxZTUH9ri+pwZO0NtQfSWg@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAEZv3cq-md7==pJrKTghg-K3AcXdcxZTUH9ri+pwZO0NtQfSWg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/45197a47-fadd-4588-9042-8a22da5f9148%40aklaver.com>
Precedence: bulk


On 8/2/24 9:32 AM, Andy Hartman wrote:
> How can I tell that?

I don't use NET or npgsql so I getting out of my depth here.

The first thing I would do is look at the package/installer you used to 
load npgsql for version info.

Second look at Installed Software and see if the version is reported there.

> 
>   Thanks.
> 
> On Fri, Aug 2, 2024 at 12:18 PM Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>> 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
>     <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>      > <mailto:adrian.klaver@aklaver.com
>     <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>     <mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>
>      >
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com