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> wrote:

> Client means Postgres Server / FDW in that case?
>
>
>
>
>
>
>
> *Von:* Hemil Ruparel <hemilruparel2002(at)gmail(dot)com>
> *Gesendet:* Dienstag, 1. Dezember 2020 16:08
> *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
>
>
>
> 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> 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
>
>
>
>