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

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