Received: from gauss.deltav.hu (deltav.hu [213.163.0.2]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f34CEq816999 for ; Wed, 4 Apr 2001 08:14:52 -0400 (EDT) (envelope-from ltibor@mail.tiszanet.hu) Received: from pcltibor (eko-gw.ekopark.hu [213.163.10.100]) by gauss.deltav.hu (Netscape Messaging Server 3.6) with SMTP id AAA4CBC; Mon, 2 Apr 2001 11:49:53 +0200 From: =?iso-8859-1?B?TOFzemzzIFRpYm9y?= To: "dhninh" Cc: "pgsql-interfaces" Subject: RE: connect to MS SQL server Date: Mon, 2 Apr 2001 11:45:56 +0200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-Reply-To: <007701c0b73b$800f1740$7e3ca8c0@dhninh> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 X-Archive-Number: 200104/11 X-Sequence-Number: 1394 > Now I want to use Postgres as frontend to connect to MS SQL server > on a Windows machine . Is it possible ? No. In your terms Postgres is a backend, not a frontend. What you've installed with RedHat is a PostgreSQL server (backend). Of course you can write, use frontends (there are some with the ditribution, eg. psql) with PostgreSQL from the Linux box or from any Windows machine, but only for accessing PostgreSQL backends. This list is only for these issues. The PostgreSQL backend uses its own backend protocol as the M$ SQL Server does. They are absolutely incompatible. So use a backend for M$ SQL on Windows. You needn't use any PostgreSQL related thing... Please refer your SQL Server documentation, or visit http://www.microsoft.com/Servers/ Regards, Tibor Laszlo ltibor@mail.tiszanet.hu