It needs to be installed on the machine with postgres On Tue, Dec 1, 2020 at 8:53 PM Zwettler Markus (OIZ) < [email protected]> wrote:
> 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]> wrote: > > Client means Postgres Server / FDW in that case? > > > > > > > > *Von:* Hemil Ruparel <[email protected]> > *Gesendet:* Dienstag, 1. Dezember 2020 16:08 > *An:* Zwettler Markus (OIZ) <[email protected]> > *Cc:* [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]> 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 > > > >
