public inbox for [email protected]  

help / color / mirror / Atom feed

From: Vijay Reddy <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: Fwd: ODBC_FDW not reading Foreign Tables
Date: Tue, 2 Dec 2025 01:36:56 +0530
Message-ID: <CAHDXC8rKFk3KDCopWpd103dcQ+ggDH77E=PWHhog99EQChKC1Q@mail.gmail.com> (raw)
In-Reply-To: <CAHDXC8o7BBPiabj-5avJy4+nuVMTeDDzgviAd7wwAKbZmKHS-A@mail.gmail.com>
References: <CAHDXC8o7BBPiabj-5avJy4+nuVMTeDDzgviAd7wwAKbZmKHS-A@mail.gmail.com>

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

view thread (2+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Fwd: ODBC_FDW not reading Foreign Tables
  In-Reply-To: <CAHDXC8rKFk3KDCopWpd103dcQ+ggDH77E=PWHhog99EQChKC1Q@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox