That worked for me... I made the change in my hba file for the host that
needs to connect and it works. I wish I had enough experience in that
matter to help you out, but I don't...
Good luck,
Thomas
==============================================================
| tlester@iakom.com | Thomas Lester |
| http://www.iakom.com | System Administrator |
| | Iakom |
==============================================================
On Mon, 1 Jun 1998, Peter Mount wrote:
>
> ---------- 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
>
>
>
>