Fwd: ODBC_FDW not reading Foreign Tables - Mailing list pgsql-general

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.