Received: from iconmail.bellatlantic.net (iconmail.bellatlantic.net
	[199.173.162.30]) by hub.org (8.9.1/8.9.1) with ESMTP id VAA03220
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 3 Nov 1998 21:40:59 -0500 (EST)
	(envelope-from daybee@bellatlantic.net)
Received: from bellatlantic.net (client196-126-68.bellatlantic.net
	[151.196.126.68])
	by iconmail.bellatlantic.net (IConNet Sendmail) with ESMTP id VAA19407;
	Tue, 3 Nov 1998 21:03:52 -0500 (EST)
Message-ID: <363FB5FB.A2F53C6D@bellatlantic.net>
Date: Tue, 03 Nov 1998 21:03:40 -0500
From: David Hartwig <daybee@bellatlantic.net>
Organization: Home
X-Mailer: Mozilla 4.5b2 [en] (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
To: Michael Yeung <michaely@alphanet.net.au>
CC: "'pgsql-interfaces@postgreSQL.org'" <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Configuring
References: <01BE07D4.9F50B3C0.michaely@alphanet.net.au>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



Michael Yeung wrote:

> Dear all,
>
> Can u please advise me how to configure the ODBC connections thru Gateway ?!
>
> The Database server is outside the firewall !!
>

This is not (should not) be an ODBC or PostgreSQL issue.  It is a network
administration issue.   It is no different than telnet'ing of ftp'ing to the
outside world.  All connections are outbound from the client side.   As long as
you can resolve IP addresses entered into the ODBC configuration, and your
firewall allows outbound access on your service port, (5432 by default) you
should be ok.

However, there is the basic configuration that must be dealt with.   See the FAQ
at: http://www.insightdist.com/psqlodbc for details on the connection checklist.