Thread

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

PG Bug reporting form <noreply@postgresql.org> — 2025-12-01T20:11:16Z

The following bug has been logged on the website:

Bug reference:      19339
Logged by:          Vijay Reddy
Email address:      vijay.reddy@programming.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.