To: David Millen <dave@largesalad.co.uk>
cc: PosrgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: odbc, postgresql and cobalt Qube/RaQ3 
In-reply-to: <396891E1.9BD3B85C@largesalad.co.uk> 
References: <396891E1.9BD3B85C@largesalad.co.uk>
Comments: In-reply-to David Millen <dave@largesalad.co.uk>
	message dated "Sun, 09 Jul 2000 14:53:22 -0000"
Date: Tue, 11 Jul 2000 11:48:27 -0400
Message-ID: <804.963330507@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

David Millen <dave@largesalad.co.uk> writes:
> Again, from psql, the system works well and the pg* commands that I have
> tried work, but I can't get a PostgreSQL ODBC connection from Star
> Office on the host machine, which *does* work with MyODBC, and
> unfortunately, my wife's machine has gone feet up so I can't test
> networked ODBC.

psql will do local connections via a Unix-domain socket, whereas I
believe ODBC always wants to use a TCP connection.  So, a couple of
obvious things to check: is the postmaster started with "-i" switch to
enable TCP connections?  Do you have an entry in pg_hba.conf allowing
connections from the proper IP address?

If you can get psql to start with "-h localhost" then this is the
wrong answer.

			regards, tom lane