> Betreff: Re: AW: FDW using remote ODBC driver
>
> On Tue, 2020-12-01 at 15:23 +, 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?
>
&g
On Tue, 2020-12-01 at 15:23 +, 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
at 8:43 PM Zwettler Markus (OIZ) <
> markus.zwett...@zuerich.ch> wrote:
>
> Client means Postgres Server / FDW in that case?
>
>
>
>
>
>
>
> *Von:* Hemil Ruparel
> *Gesendet:* Dienstag, 1. Dezember 2020 16:08
> *An:* Zwettler Markus (OIZ)
> *Cc:* pgsq
: Zwettler Markus (OIZ)
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
that case?
>
>
>
>
>
>
>
> *Von:* Hemil Ruparel
> *Gesendet:* Dienstag, 1. Dezember 2020 16:08
> *An:* Zwettler Markus (OIZ)
> *Cc:* pgsql-general@lists.postgresql.org
> *Betreff:* Re: FDW using remote ODBC driver
>
>
>
> Yes. The driver needs to be on the client
&g
Client means Postgres Server / FDW in that case?
Von: Hemil Ruparel
Gesendet: Dienstag, 1. Dezember 2020 16:08
An: Zwettler Markus (OIZ)
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
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
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
