Re: what do I wrong???

----- Original Message -----
From: Mileta Vinerte
To: Borsos József
Sent: Tuesday, January 28, 2003 3:04 PM
Subject: Re: [PHP] what do I wrong???

Hi Jozsef,

Ther is my code (db_connect.php):

<?php
//*********************************************************************************
// db_connect.php
//
// 1. Connect to the server
// 2. Connect to the database with the username=postgres and pw=postgre$
//
//*********************************************************************************

$server="172.30.30.27";
$port="5432";
$db="doors";
$dbusername="postgres";
$dbuserpw="postgre$";

//connect to server
$serverconn =pg_Connect($server, $port,$db);

if(!$serverconn)
{
echo "ERROR: Connection to Server failed!";
exit;
}

$dbconn =pg_pconnect("dbname=$db user=$dbusername password=$dbuserpw");

if(!$dbconn)
{
echo "ERROR: Connection to Database failed!";
exit;
}
?>

Borsos József wrote:

$conn_string = "host=x.x.x.x port=5432 dbname=xxxx user=COMPAX password=xxxx";
$connect = pg_connect($conn_string);

RESULT:

Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: Password authentication failed for user 'COMPAX' . in xxx on line 4

Thanks for helping, but this is the answer:

Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: fe_sendauth: no password supplied . in C:\Inetpub\wwwroot\Borsos\db_connect.php on line 17
ERROR: Connection to Server failed!