Re: odbc, postgresql and cobalt Qube/RaQ3

David Millen <dave(at)largesalad(dot)co(dot)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