AW: FDW using remote ODBC driver

Wrong direction.

I want to do a Connection FROM Postgres(at)Linux using fdw + odbc TO SQL-Server(at)Windows(dot)

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 <hemilruparel2002(at)gmail(dot)com>
Gesendet: Dienstag, 1. Dezember 2020 16:17
An: Zwettler Markus (OIZ) <Markus(dot)Zwettler(at)zuerich(dot)ch>
Cc: pgsql-general(at)lists(dot)postgresql(dot)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(dot)Zwettler(at)zuerich(dot)ch<mailto:Markus(dot)Zwettler(at)zuerich(dot)ch>> wrote:
Client means Postgres Server / FDW in that case?

Von: Hemil Ruparel <hemilruparel2002(at)gmail(dot)com<mailto:hemilruparel2002(at)gmail(dot)com>>
Gesendet: Dienstag, 1. Dezember 2020 16:08
An: Zwettler Markus (OIZ) <Markus(dot)Zwettler(at)zuerich(dot)ch<mailto:Markus(dot)Zwettler(at)zuerich(dot)ch>>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org<mailto:pgsql-general(at)lists(dot)postgresql(dot)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(dot)Zwettler(at)zuerich(dot)ch<mailto:Markus(dot)Zwettler(at)zuerich(dot)ch>> wrote:
Hi,

Can I create a FDW connection using an ODBC driver which is installed on a remote host, e.g.

Postgres(at)Linux ==> FDW ==> ODBC(at)Windows ==> SQL-Server

In other words, must the ODBC driver be installed on the local Linux system?

Thanks,
Markus