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 по дате отправления: