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@zuerich.ch> wrote:

Client means Postgres Server / FDW in that case?

Von: Hemil Ruparel <hemilruparel2002@gmail.com>
Gesendet: Dienstag, 1. Dezember 2020 16:08
An: Zwettler Markus (OIZ) <Markus.Zwettler@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.Zwettler@zuerich.ch<mailto:Markus.Zwettler@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

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@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 <hemilruparel2002@gmail.com>
Gesendet: Dienstag, 1. Dezember 2020 16:17
An: Zwettler Markus (OIZ) <Markus.Zwettler@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.Zwettler@zuerich.ch<mailto:Markus.Zwettler@zuerich.ch>> wrote:
Client means Postgres Server / FDW in that case?

Von: Hemil Ruparel <hemilruparel2002@gmail.com<mailto:hemilruparel2002@gmail.com>>
Gesendet: Dienstag, 1. Dezember 2020 16:08
An: Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch<mailto:Markus.Zwettler@zuerich.ch>>
Cc: pgsql-general@lists.postgresql.org<mailto: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.Zwettler@zuerich.ch<mailto:Markus.Zwettler@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

It needs to be installed on the machine with postgres

On Tue, Dec 1, 2020 at 8:53 PM Zwettler Markus (OIZ) <
Markus.Zwettler@zuerich.ch> wrote:

On Tue, 2020-12-01 at 15:23 +0000, Zwettler Markus (OIZ) wrote:

I want to do a Connection FROM Postgres@Linux using fdw + odbc TO SQL-Server@Windows.

Is there any reason for not using tds_fdw?

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

Question has been for pure interest. I could use a remote ODBC driver with Oracle ;-)