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 <hemilruparel2002@xxxxxxxxx>
Gesendet: Dienstag, 1. Dezember 2020 16:17
An: Zwettler Markus (OIZ) <Markus.Zwettler@xxxxxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
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.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
It needs to be installed on the machine with postgres
On Tue, Dec 1, 2020 at 8:53 PM Zwettler Markus (OIZ) <Markus.Zwettler@xxxxxxxxxx> wrote:
