Re: Can't get ODBC from Windows to Linux/Postgres to work

I've also had to use the ip address of the server instead of the name of
it. can't figure out why though as all my other apps have no problems with
name service.
corey

-----Original Message-----
From: Oliver Elphick [SMTP:olly(at)lfix(dot)co(dot)uk]
Sent: Monday, March 11, 2002 12:34 PM
To: jeff(at)dgjc(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Can't get ODBC from Windows to Linux/Postgres to
work

On Mon, 2002-03-11 at 23:03, Jeff Martin wrote:
> I get the following error when trying to connect to the ODBC source from
MS
> Access
>
> ODBC call failed:
> Could not connect to the server.
> Could not connect to the remote socket. (#101)[Microsoft][ODBC Driver
> Manager]Connection not open(#0)
>
>
> What step am I missing here? Thanks for any help.

Does pg_hba.conf allow TCP/IP access. Is the postmaster listening for
TCP/IP connects.

Is there anything in the server's log?

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C

"I am the vine, ye are the branches; He that abideth in
me, and I in him, the same bringeth forth much fruit;
for without me ye can do nothing."
John 15:5

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly