Re: Connection string - Mailing list pgsql-general

From Harpreet Dhaliwal
Subject Re: Connection string
Date
Msg-id d86a77ef0608131544g2acc7d40na48c0ecf458dd651@mail.gmail.com
Whole thread Raw
In response to Re: Connection string  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
ECPGdebug(1, stderr);
After including this line of code in my program,
it says:

raising sqlcode -402 in line 14, 'could not connect to database dbxyz in line 14'

Thanks,
~Harpreet.

On 8/13/06, Michael Fuhr <mike@fuhr.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

pgsql-general by date:

Previous
From: "Harpreet Dhaliwal"
Date:
Subject: Re: Connection string
Next
From: "Harpreet Dhaliwal"
Date:
Subject: Re: Connection string