pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #19339: odbc_fdw extension, Not able to read data from foreign tables
4+ messages / 3 participants
[nested] [flat]
* BUG #19339: odbc_fdw extension, Not able to read data from foreign tables
@ 2025-12-01 20:11 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 4+ messages in thread
From: PG Bug reporting form @ 2025-12-01 20:11 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: vijay.reddy@programming.com
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: BUG #19339: odbc_fdw extension, Not able to read data from foreign tables
@ 2025-12-10 11:41 Etsuro Fujita <etsuro.fujita@gmail.com>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 4+ messages in thread
From: Etsuro Fujita @ 2025-12-10 11:41 UTC (permalink / raw)
To: vijay.reddy@programming.com; pgsql-bugs@lists.postgresql.org
On Tue, Dec 2, 2025 at 3:29 PM PG Bug reporting form
<noreply@postgresql.org> wrote:
> I am facing an issue with odbc_fdw. I need your help.
[snip]
> 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.
I think that this message was produced by the extension.
The extension is developed externally, not by the Postgres project, so
I recommend sending this to the development team of it.
Best regards,
Etsuro Fujita
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: BUG #19339: odbc_fdw extension, Not able to read data from foreign tables
@ 2025-12-10 15:50 Vijay Reddy <vijay.reddy@programming.com>
parent: Etsuro Fujita <etsuro.fujita@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Vijay Reddy @ 2025-12-10 15:50 UTC (permalink / raw)
To: Etsuro Fujita <etsuro.fujita@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org
Hi Etsuro,
Thanks for the pointer. The issue is resolved. We were able to fix the
issue internally.
Best regards,
Vijay Reddy
Thanks & Regards,
Vijay Reddy | Database Architect
Programming.com
vijay.reddy@programming.com
Gurgaon | Bangalore | Mohali | IT Park Panchkula| IT Park Dehradun | Pune
| Chennai
New York | Los Angeles | Ft Lauderdale | San Diego | San Jose |
Phoenix | Chicago
On Wed, Dec 10, 2025 at 5:11 PM Etsuro Fujita <etsuro.fujita@gmail.com>
wrote:
> On Tue, Dec 2, 2025 at 3:29 PM PG Bug reporting form
> <noreply@postgresql.org> wrote:
> > I am facing an issue with odbc_fdw. I need your help.
>
> [snip]
>
> > 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.
>
> I think that this message was produced by the extension.
>
> The extension is developed externally, not by the Postgres project, so
> I recommend sending this to the development team of it.
>
> Best regards,
> Etsuro Fujita
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: BUG #19339: odbc_fdw extension, Not able to read data from foreign tables
@ 2025-12-11 11:01 Etsuro Fujita <etsuro.fujita@gmail.com>
parent: Vijay Reddy <vijay.reddy@programming.com>
0 siblings, 0 replies; 4+ messages in thread
From: Etsuro Fujita @ 2025-12-11 11:01 UTC (permalink / raw)
To: Vijay Reddy <vijay.reddy@programming.com>; +Cc: pgsql-bugs@lists.postgresql.org
On Thu, Dec 11, 2025 at 12:51 AM Vijay Reddy
<vijay.reddy@programming.com> wrote:
> The issue is resolved. We were able to fix the issue internally.
That's good to hear!
Best regards,
Etsuro Fujita
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2025-12-11 11:01 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-12-01 20:11 BUG #19339: odbc_fdw extension, Not able to read data from foreign tables PG Bug reporting form <noreply@postgresql.org>
2025-12-10 11:41 ` Etsuro Fujita <etsuro.fujita@gmail.com>
2025-12-10 15:50 ` Vijay Reddy <vijay.reddy@programming.com>
2025-12-11 11:01 ` Etsuro Fujita <etsuro.fujita@gmail.com>
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