Postgres Pro
Downloads
Home   >   mailing lists

AW: FDW using remote ODBC driver - Mailing list pgsql-general

From Zwettler Markus (OIZ)
Subject AW: FDW using remote ODBC driver
Date
Msg-id c94ca7440b224e22ba8ec6f1d1fba07b@zuerich.ch
Whole thread Raw
In response to Re: FDW using remote ODBC driver  (Hemil Ruparel <hemilruparel2002@gmail.com>)
Responses Re: FDW using remote ODBC driver
List pgsql-general
Tree view

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> 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

 

pgsql-general by date:

Previous
From: mobigroup
Date:
Subject: Re: PostgreSQL 12.4 Parallel Query doesn't work while EXPLAIN is OK
Next
From: Hemil Ruparel
Date:
Subject: Re: FDW using remote ODBC driver