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:17An: Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>Cc: pgsql-general@lists.postgresql.orgBetreff: 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:08An: Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>Cc: pgsql-general@lists.postgresql.orgBetreff: 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
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:17An: Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>Cc: pgsql-general@lists.postgresql.orgBetreff: 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:08An: Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>Cc: pgsql-general@lists.postgresql.orgBetreff: 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
Client means Postgres Server / FDW in that case?
Von: Hemil Ruparel <hemilruparel2002@gmail.com> Gesendet: Dienstag, 1. Dezember 2020 16:08An: Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>Cc: pgsql-general@lists.postgresql.orgBetreff: 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
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:
Соглашаюсь с условиями обработки персональных данных