public inbox for [email protected]help / color / mirror / Atom feed
Re: Connection Issue 3+ messages / 2 participants [nested] [flat]
* Re: Connection Issue @ 2024-08-02 16:18 Adrian Klaver <[email protected]> 2024-08-02 16:32 ` Re: Connection Issue Andy Hartman <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Adrian Klaver @ 2024-08-02 16:18 UTC (permalink / raw) To: Andy Hartman <[email protected]>; +Cc: [email protected] <[email protected]> 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 <[email protected] > <mailto:[email protected]>> 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 > [email protected] <mailto:[email protected]> > -- Adrian Klaver [email protected] ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Connection Issue 2024-08-02 16:18 Re: Connection Issue Adrian Klaver <[email protected]> @ 2024-08-02 16:32 ` Andy Hartman <[email protected]> 2024-08-02 16:44 ` Re: Connection Issue Adrian Klaver <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Andy Hartman @ 2024-08-02 16:32 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; +Cc: [email protected] <[email protected]> How can I tell that? Thanks. On Fri, Aug 2, 2024 at 12:18 PM Adrian Klaver <[email protected]> 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 <[email protected] > > <mailto:[email protected]>> 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 > > [email protected] <mailto:[email protected]> > > > > -- > Adrian Klaver > [email protected] > ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Connection Issue 2024-08-02 16:18 Re: Connection Issue Adrian Klaver <[email protected]> 2024-08-02 16:32 ` Re: Connection Issue Andy Hartman <[email protected]> @ 2024-08-02 16:44 ` Adrian Klaver <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Adrian Klaver @ 2024-08-02 16:44 UTC (permalink / raw) To: Andy Hartman <[email protected]>; +Cc: [email protected] <[email protected]> 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 <[email protected] > <mailto:[email protected]>> 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 > <[email protected] <mailto:[email protected]> > > <mailto:[email protected] > <mailto:[email protected]>>> 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 > > [email protected] <mailto:[email protected]> > <mailto:[email protected] <mailto:[email protected]>> > > > > -- > Adrian Klaver > [email protected] <mailto:[email protected]> > -- Adrian Klaver [email protected] ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-08-02 16:44 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-08-02 16:18 Re: Connection Issue Adrian Klaver <[email protected]> 2024-08-02 16:32 ` Andy Hartman <[email protected]> 2024-08-02 16:44 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox