It needs to be installed on the machine with postgres On Tue, Dec 1, 2020 at 8:53 PM Zwettler Markus (OIZ) < markus.zwett...@zuerich.ch> 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 <hemilruparel2...@gmail.com> > *Gesendet:* Dienstag, 1. Dezember 2020 16:17 > *An:* Zwettler Markus (OIZ) <markus.zwett...@zuerich.ch> > *Cc:* pgsql-general@lists.postgresql.org > *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) < > markus.zwett...@zuerich.ch> wrote: > > Client means Postgres Server / FDW in that case? > > > > > > > > *Von:* Hemil Ruparel <hemilruparel2...@gmail.com> > *Gesendet:* Dienstag, 1. Dezember 2020 16:08 > *An:* Zwettler Markus (OIZ) <markus.zwett...@zuerich.ch> > *Cc:* pgsql-general@lists.postgresql.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.zwett...@zuerich.ch> 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 > > > >
