connecting to postgresql - pwd authent. failed

[bitmapbrother]

Hi I got another problem
When I try to connect to postgres server I will get this message:

SQL Error: FATAL: password authentication failed for user "bitmapbrother"

... but ZConnection->User is set to "janitor" which is working account - "bitmapbrother" is my windows login/username ... I am getting crazy about that especially coz I am able to connect to this server without problems using native libpq.dll. Thx for any ideas.

[orlando]

Hi,

I was passing for this error to a passed time, discovered that I was omitting the connection door then it I was connecting door 5432 and my area for test was in the 5433 where the user and the password were different. E an idea, therefore is this does not have problems in connecting to a base PostGre-SQL using TZConnection

ex:
TZConnection1.HostName:= ip;
TZConnection1.protocol :=PostGresql-7.4;
TZConnection1.database :=NameDatabase;
TzConnection1.user :=myuser;
TZConnection1.Port :=5432;
TZConnection1.Password :=mypass;
TZConnection1.Properties.loadFormFile(myfile);
TZConnection1.Connect;

Regards

Edmilson

[bitmapbrother]

my parameters should be ok - i am using them while connecting using native postgre api

[klchin]

Hi,


Hv u edit the pg_dba.conf to add the IP

and postgreSQL

listen_addresses = '*'

[yohanip]

you need to specify the database name on the parameter sets to ensure that the zeoslib to use the 'user' parameter