From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: vijay.reddy@programming.com
Subject: BUG #19339: odbc_fdw extension, Not able to read data from foreign tables
Date: Mon, 01 Dec 2025 20:11:16 +0000
Message-ID: <19339-546a4f4746cff2a3@postgresql.org> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, vijay.reddy@programming.com
Subject: Re: BUG #19339: odbc_fdw extension, Not able to read data from foreign tables
In-Reply-To: <19339-546a4f4746cff2a3@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox