Connection Issue

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

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

--
Adrian Klaver
adrian.klaver@aklaver.com

How can I tell that?

Thanks.

On Fri, Aug 2, 2024 at 12:18 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

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

On 8/2/24 9:47 AM, Andy Hartman wrote:
Please don't top post. Use inline or bottom posting.

Looks like 4.5

From here:

https://www.npgsql.org/doc/performance.html

Release notes

I see 4.1 and 5.0, no 4.5

My bet 4.5 is the NET version you are working with.

--
Adrian Klaver
adrian.klaver@aklaver.com

On 8/2/24 9:55 AM, Andy Hartman wrote:

How do I get latest and greatest?

Go to the previously shown link and read the Installation section.

On Fri, Aug 2, 2024 at 12:52 PM Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>> wrote:

On 8/2/24 9:47 AM, Andy Hartman wrote:
Please don't top post. Use inline or bottom posting.

Looks like 4.5

 From here:

https://www.npgsql.org/doc/performance.html
<https://www.npgsql.org/doc/performance.html&gt;

Release notes

I see 4.1 and 5.0, no 4.5

My bet 4.5 is the NET version you are working with.

--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com