public inbox for [email protected]
help / color / mirror / Atom feedFwd: ODBC_FDW not reading Foreign Tables
2+ messages / 2 participants
[nested] [flat]
* Fwd: ODBC_FDW not reading Foreign Tables
@ 2025-12-01 20:06 Vijay Reddy <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Vijay Reddy @ 2025-12-01 20:06 UTC (permalink / raw)
To: pgsql-general; +Cc: [email protected]
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
[email protected]
Gurgaon | Bangalore | Mohali | IT Park Panchkula| IT Park Dehradun | Pune
| Chennai
New York | Los Angeles | Ft Lauderdale | San Diego | San Jose |
Phoenix | Chicago
Attachments:
[application/vnd.openxmlformats-officedocument.wordprocessingml.document] odbc_fdw between postgreSQL and SQL db (Remote) (2).docx (354.5K, 3-odbc_fdw%20between%20postgreSQL%20and%20SQL%20db%20%28Remote%29%20%282%29.docx)
download
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Fwd: ODBC_FDW not reading Foreign Tables
@ 2025-12-02 16:26 Adrian Klaver <[email protected]>
parent: Vijay Reddy <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Adrian Klaver @ 2025-12-02 16:26 UTC (permalink / raw)
To: Vijay Reddy <[email protected]>; pgsql-general; +Cc: [email protected]
On 12/1/25 12:06, Vijay Reddy wrote:
> 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.
odbc_fdw is a third party extension you will need to contact other
resources:
1) The dedicated Postgresql ODBC list:
https://www.postgresql.org/list/pgsql-odbc/
2) The issues page for the driver maintainers:
https://github.com/CartoDB/odbc_fdw/issues
If you need immediate attention then you will need to reach out to one
of the professional support companies listed here:
https://www.postgresql.org/support/professional_support/
When you do the above you will need to provide more information, at least:
1) Postgres version
2) SQL Server version.
3) OS version.
4) What fdw_win64_17_bin is and where you installed it from.
5) The location of your Postgres installation and ODBC installation
>
>
> 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
> [email protected] <mailto:[email protected]>
> Gurgaon | Bangalore | Mohali | IT Park Panchkula| IT Park Dehradun |
> Pune | Chennai
> New York | Los Angeles | Ft Lauderdale | San Diego | San Jose |
> Phoenix | Chicago
>
>
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-12-02 16:26 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-12-01 20:06 Fwd: ODBC_FDW not reading Foreign Tables Vijay Reddy <[email protected]>
2025-12-02 16:26 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox