From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Millen <dave@largesalad.co.uk>
Cc: PosrgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: odbc, postgresql and cobalt Qube/RaQ3
Date: Tue, 11 Jul 2000 11:48:27 -0400
Message-ID: <804.963330507@sss.pgh.pa.us> (raw)
In-Reply-To: <396891E1.9BD3B85C@largesalad.co.uk>
References: <396891E1.9BD3B85C@largesalad.co.uk>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, dave@largesalad.co.uk
Subject: Re: odbc, postgresql and cobalt Qube/RaQ3
In-Reply-To: <804.963330507@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox