Re: connect to MS SQL server

From: "ADBAAMD" <adba(dot)amdocs(at)bell(dot)ca>
To: "dhninh" <dhninh(at)cmc(dot)com(dot)vn>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: connect to MS SQL server
Date: 2001-04-02 17:52:04
Message-ID: 3AC8BC44.4000607@bell.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)bell(dot)ca
/ \ http://terravista.pt./Enseada/1989/ mailto:leandrod(at)amdocs(dot)com

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message José Luiz 2001-04-02 21:48:28 En: Error during update from version 6.5.3 to version 7.03
Previous Message Lars Forseth 2001-04-02 17:14:53 Postgres 7.0.3 and ODBC