AW: FDW using remote ODBC driver

Поиск
Список
Период
Сортировка
От Zwettler Markus (OIZ)
Тема AW: FDW using remote ODBC driver
Дата
Msg-id 1b7abe76b74445a0830e9c310d0a71c1@zuerich.ch
обсуждение исходный текст
Ответ на Re: FDW using remote ODBC driver  (Hemil Ruparel <hemilruparel2002@gmail.com>)
Ответы Re: FDW using remote ODBC driver
Re: AW: FDW using remote ODBC driver
Список pgsql-general
Дерево обсуждения

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

 

В списке pgsql-general по дате отправления:

Предыдущее
От: Hemil Ruparel
Дата:
Сообщение: Re: FDW using remote ODBC driver
Следующее
От: Hemil Ruparel
Дата:
Сообщение: Re: FDW using remote ODBC driver