Re: [ADMIN] ODBC Call fail? (fwd)

---------- Forwarded message ----------
Date: Sun, 31 May 1998 18:52:53 +0530
From: Venugopal <venu@gtsl.co.in>
To: Peter Mount <pgsqladmin@retep.org.uk>
Subject: Re: [ADMIN] ODBC Call fail?
Newsgroups: comp.databases.postgresql.admin

Peter Mount wrote:

> On Sat, 30 May 1998, Thomas Lester wrote:
>
> > Everytime I try to hit my database from my ODBC driver I get ODBC call failed.
> > I have a pretty good idea why.  I do not have an entry for postgres in my
> > /etc/services (I'm using solaris 2.6).  Am I correct?
>
> You don't need an entry.
>
> Are you running the postmaster with the -i argument which enables TCP/IP
> communication?
>
>

Hi, I am facing the same problem even though i run postmaster with "-i"  and -p
5432 option.
psql connects over the loopback but,
psql -d mydb -h 192.168.0.34 -p 5432 - fails to connect. (192.168.0.34 is my IP)

I rectified this by editing the /var/lib/pgsql/pg_hba.conf to add

host         all        192.168.0.0    255.255.255.0     trust

at the end of the file....
I know this is not ideal, with no security, but then , i can connect using ip...
But i am still not able to connect thru ODBC on Win95... any solutions ?

venu