AW: FDW using remote ODBC driver

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