AW: FDW using remote ODBC driver

["Zwettler Markus (OIZ)" <Markus.Zwettler@xxxxxxxxxx>]

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