Re: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed - Mailing list pgsql-general

From Adrian Klaver
Subject Re: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed
Date
Msg-id d646ccc3-63cb-4009-a5a8-cdd9cbee52a3@aklaver.com
Whole thread Raw
In response to tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed  ("Zacher, Stacy" <szacher@mcw.edu>)
List pgsql-general
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.
> 

> 
> Also, I recreated the FDW that is broken on another server (Postgres 16 
> on Rocky Linux 8) and it works there.

What version of tds_fdw are you using in this case?

Recreated without doing the tds_fdw upgrade/revert sequence?

> Thank you,
> 
> Stacy
> 
> szacher@mcw.edu
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed
Next
From: Igor Korot
Date:
Subject: Insert records in the tavke only if they are not exist