HELP FOR POSTGRESQL NEEDED...

<p>Hello.I am experiencing a quite strange behavior with my <strong>postgreSQL database</strong>.<p>I have edited the
file<strong>pg_hba.conf</strong> like this:<p># TYPE     DATABASE    IP_ADDRESS    MASK               AUTH_TYPE 
AUTH_ARGUMENT<br/>local      all                                                                       password<br
/>host      all         127.0.0.1     255.255.255.255                   password<p>in order to require user
authentication.Thisworks perfectly when I connect to the database with <strong>psql</strong> or
<strong>pgaccess</strong>and I'm able to perform<p>all kinds of queries.<p>However when I try to connect to the
databasewith <strong>C++</strong> even though it allows me to connect (providing the correct username &
password)<p><strong>allthe queries fail...</strong>The C++ code I use is the following:<p><br />#include
<stdio.h><br/>#include <stdlib.h><br />#include <string.h><br />#include <iostream.h><br
/>#include<string><p>#include "libpq++.h"<p>using namespace std;<p><br />int main()<p>{<br />  string
login,pwd;<br/>  char name[10];<br />  char query_string[256];<p>  cout << ">username:";<br />  cin >>
login;<br/>  cout << ">password:";<br />  cin >> pwd;<p>  cout<<"user to search:";<br />  cin
>>name;<p><br />  // Open the connection to the database and make sure it's OK<p>  PgDatabase
data("dbname=goumero");<p><br/>  char       *pghost,*pgport,*pgoptions,*pgtty;<br />  char       *dbName;<p>   pghost =
NULL;             /* host name of the backend server */<br />   pgport = NULL;              /* port of the backend
server*/<br />   pgoptions = NULL;         /* special options to start up the backend server */<br />   pgtty =
NULL;              /* debugging tty for the backend server */<br />   dbName = "goumero";<p>   PGconn* conn;<p>   conn
= PQsetdbLogin(pghost,pgport,pgoptions,pgtty,dbName,login.c_str(),pwd.c_str()) ;<p>  if (PQstatus(conn) ==
CONNECTION_BAD) {<br />        fprintf(stderr, "Connection to database '%s' failed.\n", dbName);<br />       
fprintf(stderr,"%s", PQerrorMessage(conn));<br />        return 1;<br />  }<br />  else<br />      //Connection
successful...<p><br/>      data.Exec("BEGIN WORK");<br />      data.Exec("LOCK TABLE account in ACCESS EXCLUSIVE 
MODE");<p><br/>            sprintf(query_string,                               // create an SQL query string<br
/>                   "SELECT *   \<br />                     FROM account \<br />                     WHERE name='%s'"
,name);<br />              if ( !data.ExecTuplesOk(query_string) )             // send the query<br />            {<br
/>               cerr << "query failed." << endl;<br />                exit(1);<br />           
}<p>           for (int i=0; i < data.Tuples(); i++)               // loop through all rows returned<br
/>                   cout << data.GetValue(i,0) << endl;   // print the value
returned<p>/**************************************************************************************/<p>     
data.Exec("COMMITWORK");<br />      PQfinish(conn);<p>return 0;<p>} // End main()<p><strong><font
color="blue"><u>Note</u></font></strong>:Thesame query above is correctly executed when I connect with
<strong>psql</strong>.<p><strong><u>Also if I remove the user authentication stuff then the same code is
executed correctly.</u></strong><p><strong><fontcolor="red">I would be grateful if you helped me - I'm
desperate....</font></strong><p>  <p> <p><br/> <p> <p><br /> <p> <p><br /><hr size="1" /><b>Do You Yahoo!?</b><br
/>Αποκτήστετην δωρεάν σας @yahoo.gr διεύθυνση στο <a href="http://www.otenet.gr/">Yahoo! Mail</a>.<br />