Re: Connection Issue

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(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> > <mailto: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>
> <mailto:adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
> >
>
> --
> 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