Re: connect to MS SQL server - Mailing list pgsql-novice

From ADBAAMD
Subject Re: connect to MS SQL server
Date
Msg-id 3AC8BC44.4000607@bell.ca
Whole thread Raw
In response to connect to MS SQL server  ("dhninh" <dhninh@cmc.com.vn>)
List pgsql-novice
dhninh wrote:

>
> Now I want to use Postgres as frontend to connect to MS SQL server on a
> Windows machine . Is it possible ?

    I don't think so.   pgsql still doesn't have distributed capabilities
AFAIK, neither is it an ODBC client - just an ODBC server.

    Now perhaps if MS SQL Server can act as an ODBC client you may be able to
use it as a front end to pgsql.  This sounds more interesting, since
inherently GNU/Linux and pgsql are far more reliable and simple than NT
and MS SQL Server.

    Other option would be to have an ODBC client able to access *both* pgsql
and MS SQL ODBC servers.



--
  _
/ \   Leandro Guimarães Faria Corsetti Dutra         +55 (11) 3040 8913
\ /   Amdocs at Bell Canada                          +1 (514) 786 87 47
  X    Support Center, São Paulo, Brazil          mailto:adbaamd@bell.ca
/ \   http://terravista.pt./Enseada/1989/    mailto:leandrod@amdocs.com



pgsql-novice by date:

Previous
From: Lars Forseth
Date:
Subject: Postgres 7.0.3 and ODBC
Next
From: José Luiz
Date:
Subject: En: Error during update from version 6.5.3 to version 7.03