solution is to upgrade the SQL Server to a newer
version.
Thank you,
Stacy
-Original Message-
From: Zacher, Stacy
Sent: Friday, December 6, 2024 4:11 PM
To: Adrian Klaver ;
pgsql-general@lists.postgresql.org
Subject: RE: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server
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
bu
, DB Msg: Adaptive Server
connection failed
ATTENTION: This email originated from a sender outside of MCW. Use caution when
clicking on links or opening attachments.
On 12/6/24 13:19, Zacher, Stacy wrote:
Hello:
We recently did an OS upgrade from Rocky Linux 8
Hi Adrian:
Please see my replies below:**
Thank you!
Stacy
-Original Message-
From: Adrian Klaver
Sent: Friday, December 6, 2024 3:51 PM
To: Zacher, Stacy ; pgsql-general@lists.postgresql.org
Subject: Re: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server
connection
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
bu
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 mes
