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 <[email protected]> Gesendet: Dienstag, 1. Dezember 2020 16:17 An: Zwettler Markus (OIZ) <[email protected]> Cc: [email protected] 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) <[email protected]<mailto:[email protected]>> wrote: Client means Postgres Server / FDW in that case? Von: Hemil Ruparel <[email protected]<mailto:[email protected]>> Gesendet: Dienstag, 1. Dezember 2020 16:08 An: Zwettler Markus (OIZ) <[email protected]<mailto:[email protected]>> Cc: [email protected]<mailto:[email protected]> 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) <[email protected]<mailto:[email protected]>> 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
