Wrong direction. I want to do a Connection FROM Postgres@Linux using fdw + odbc TO SQL-Server@Windows.
Question has been if the SQL-Server ODBC driver can also be installed on the remote Windows Server in that case. -Markus Von: Hemil Ruparel <hemilruparel2...@gmail.com> Gesendet: Dienstag, 1. Dezember 2020 16:17 An: Zwettler Markus (OIZ) <markus.zwett...@zuerich.ch> Cc: pgsql-general@lists.postgresql.org Betreff: Re: FDW using remote ODBC driver The machine you are trying to connect the postgres server from is the client in this case. May be a laptop or a production VM or container. On Tue, Dec 1, 2020 at 8:43 PM Zwettler Markus (OIZ) <markus.zwett...@zuerich.ch<mailto:markus.zwett...@zuerich.ch>> wrote: Client means Postgres Server / FDW in that case? Von: Hemil Ruparel <hemilruparel2...@gmail.com<mailto:hemilruparel2...@gmail.com>> Gesendet: Dienstag, 1. Dezember 2020 16:08 An: Zwettler Markus (OIZ) <markus.zwett...@zuerich.ch<mailto:markus.zwett...@zuerich.ch>> Cc: pgsql-general@lists.postgresql.org<mailto:pgsql-general@lists.postgresql.org> Betreff: Re: FDW using remote ODBC driver Yes. The driver needs to be on the client On Tue, Dec 1, 2020 at 8:34 PM Zwettler Markus (OIZ) <markus.zwett...@zuerich.ch<mailto:markus.zwett...@zuerich.ch>> wrote: Hi, Can I create a FDW connection using an ODBC driver which is installed on a remote host, e.g. Postgres@Linux ==> FDW ==> ODBC@Windows ==> SQL-Server In other words, must the ODBC driver be installed on the local Linux system? Thanks, Markus
