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
szacher@xxxxxxx
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx