Fwd: ODBC_FDW not reading Foreign Tables

Dear Postgres Support Team,

Greetings!
This is to bring to your notice that I am facing an issue with odbc_fdw
wrapper. My requirement is that I want to implement odbc_fdw
extension/wrapper in PostgreSQL 17.6.2 to read remote tables from
SQL Server (Remote db). I have the following details and attachment with
screenshots. I am working for my client (Experts.com) Need immediate
attention.

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.

Please let me know Why I am not able to read from foreign tables, correct
binaries, and further steps to read data from remote SQL DB tables. A
quick response is greatly appreciated.

Thanks & Regards,
Vijay Reddy | Database Architect
Programming.com
vijay(dot)reddy(at)programming(dot)com
Gurgaon | Bangalore | Mohali | IT Park Panchkula| IT Park Dehradun | Pune
| Chennai
New York | Los Angeles | Ft Lauderdale | San Diego | San Jose |
Phoenix | Chicago