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.Zwettler@xxxxxxxxxx> wrote:
Client means Postgres Server / FDW in that case?
Von: Hemil Ruparel <hemilruparel2002@xxxxxxxxx>
Gesendet: Dienstag, 1. Dezember 2020 16:08
An: Zwettler Markus (OIZ) <Markus.Zwettler@xxxxxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
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.Zwettler@xxxxxxxxxx> 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
