---------- 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