Postgres Pro
Downloads
Home   >   mailing lists

Thread: FDW using remote ODBC driver

FDW using remote ODBC driver

From
"Zwettler Markus (OIZ)"
Date:

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

 

Re: FDW using remote ODBC driver

From
Hemil Ruparel
Date:
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

 

AW: FDW using remote ODBC driver

From
"Zwettler Markus (OIZ)"
Date:

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

 

Re: FDW using remote ODBC driver

From
Hemil Ruparel
Date:
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:

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

 

AW: FDW using remote ODBC driver

From
"Zwettler Markus (OIZ)"
Date:

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

 

Re: FDW using remote ODBC driver

From
Hemil Ruparel
Date:
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:

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

 

Re: AW: FDW using remote ODBC driver

From
Laurenz Albe
Date:
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

AW: AW: FDW using remote ODBC driver

From
"Zwettler Markus (OIZ)"
Date:
Question has been for pure interest. I could use a remote ODBC driver with Oracle ;-)


> -----Ursprüngliche Nachricht-----
> Von: Laurenz Albe <laurenz.albe@cybertec.at>
> Gesendet: Dienstag, 1. Dezember 2020 17:14
> An: Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>; Hemil Ruparel
> <hemilruparel2002@gmail.com>
> Cc: pgsql-general@lists.postgresql.org
> Betreff: Re: AW: FDW using remote ODBC driver
> 
> 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