BUG #19339: odbc_fdw extension, Not able to read data from foreign tables

The following bug has been logged on the website:

Bug reference: 19339
Logged by: Vijay Reddy
Email address: vijay(dot)reddy(at)programming(dot)com
PostgreSQL version: 17.6
Operating system: Windows 2022
Description:

Dear PostgreSQL team,

I am facing an issue with odbc_fdw. I need your help.

Tasks completed: 1. Downloaded fdw_win64_17_bin
2. Odbc_fdw extension created.
3. Created Foreign server ( Reports_server)
4. Tested DSN between odbc and sql db ( remote live db) successfully
5. User mapping done: mapped ‘postgres’ user to sql_prod_account/*****
6. Created foreign tables.
7. Select * from the public.”IpInfo” failed with driver error.
8. Postgres user not speaking to odbc
9. Tds_fdw files downloaded, right binary not available, not able to
create tds_fdw extension with available binaries.
10. ODBC Driver 17 for SQL Server is compatible with and DSN tested
successfully and connected via 1433 and user/password to live db
11. Re-started postgres service with ‘Local System Account’ and
‘Network Service’ Account.

Issue: Not able to read foreign table data (from Remote SQL DB) due to
error.

Error: Connecting to driver
SQL State: 58000
PostgreSQL service process can not load the odbc driver or connect to the
DSN defined file.