Re: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: "Zacher, Stacy" <szacher(at)mcw(dot)edu>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed
Date: 2024-12-06 23:34:47
Message-ID: d646ccc3-63cb-4009-a5a8-cdd9cbee52a3@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)mcw(dot)edu
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michel Pelletier 2024-12-07 00:51:50 Re: Using Expanded Objects other than Arrays from plpgsql
Previous Message Adrian Klaver 2024-12-06 22:26:30 Re: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed