public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: Zacher, Stacy <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed
Date: Fri, 6 Dec 2024 13:50:34 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <CH2PR01MB57653B7D1D72D83320FDE4DEAD312@CH2PR01MB5765.prod.exchangelabs.com>
References: <CH2PR01MB57653B7D1D72D83320FDE4DEAD312@CH2PR01MB5765.prod.exchangelabs.com>

On 12/6/24 13:19, Zacher, Stacy wrote:
> Hello:
> 
> We recently did an OS upgrade from Rocky Linux 8 to 9 on a Postgres v13 
> server that has 2 Foreign data wrappers that use tds_fdw for connections 
> to 2 different SQL Servers.
> 
> After the OS upgrade, one of the FDWs stopped working for some reason 
> but the other one still works.
> 
> The error message when trying to run the import statement in psql is as 
> follows (I changed some of the names):
> 
> using psql:
> 

> I tested connecting to the server/port via ncat and it returns 
> successfully.
> 
> When I try sqlcmd or tsql, The 1477 port is static (vs. dynamic)
> 
> [postgres@rh9server bin]$ ./sqlcmd -S 141.xxx.x.xxx,1477 -C -d Pdata_db 
> -U PData_Reader -P xxxxxxxxxxxxxx
> 
> Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : TCP Provider: 
> Error code 0x2746.

Some searching mentions that this 'TCP Provider: Error code 0x2746.' can 
be related to lack of TLS 1.2 support.

I don't see your tsql connection attempt.


> The FDW that is still working is going to a SQL Server v14.x 2017 server 
> and the broken one is going to a SQL Server version 13 2016 server.

Are the SQL Server instances running on the same machine?

If not what versions of Windows are they using in each case?

> 
> Also, I recreated the FDW that is broken on another server (Postgres 16 
> on Rocky Linux 8) and it works there.
> 
> So I'm puzzled here as to why it's not working on the upgraded server, 
> yet the other FDW on the same server still works.
> 
> Any help on this issue would be greatly appreciated.
> 
> Thank you,
> 
> Stacy
> 
> [email protected]
> 

-- 
Adrian Klaver
[email protected]

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox