How can I tell that? Thanks.
On Fri, Aug 2, 2024 at 12:18 PM Adrian Klaver <adrian.kla...@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.kla...@aklaver.com > > <mailto:adrian.kla...@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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
