From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | David Millen <dave(at)largesalad(dot)co(dot)uk> |
Cc: | PosrgreSQL Interfaces <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | Re: odbc, postgresql and cobalt Qube/RaQ3 |
Date: | 2000-07-11 15:48:27 |
Message-ID: | 804.963330507@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Hitesh Patel | 2000-07-11 21:59:22 | Getting INSERT values on a trigger |
Previous Message | Allan Kelly | 2000-07-11 14:41:17 | Re: odbc, postgresql and cobalt Qube/RaQ3 |