Re: Connection string

Michael,
Please ignore my last email

At last I got error code 0.

Problem was with pg_hba.conf file

ECPGdebug(1, stderr); showed that in pg_hba.conf there was setting for
localhost only and not for other ip addresses.

I had to change the configuration for IPV4 local connections

It should have been something like

host all all 192.168.0.0/24 trust
instead of
host all all 127.0.0.1/32 trust (which is meant for localhost
only)

I think i got it...right?

thanks alot for your help. Do you anymore inputs or warnings for me on this?

I'm highly obliged MIchael..

Thanks and regards,

~Harpreet

On 8/13/06, Michael Fuhr <mike(at)fuhr(dot)org> wrote:
>
> On Sun, Aug 13, 2006 at 01:58:54AM -0400, Harpreet Dhaliwal wrote:
> > -402 sqlcode means "connection attempt to the database did not succeed"
> >
> > does this mean that my application is connecting to the database server
> but
> > somehow failing in connecting to the database dbxyz due to some
> > authentication problems???
>
> What do the server's logs say? Can you connect to the database
> from the same machine using psql? If you add the following line
> to your program before the connect, what output do you get?
>
> ECPGdebug(1, stderr);
>
> --
> Michael Fuhr
>