--- operationsengineer1(at)yahoo(dot)com wrote:
> i have the following adodb code (which shouldn't be
> too hard to figure out for those not familiar with
> $db = &ADONewConnection('postgres8');
> if (!$db) die('Connection failed');
> $db->debug = true;
> $sql_product = 'SELECT product_id, product_number
> t_product ' .
> 'ORDER BY product_number ASC';
> $sql_employee = 'SELECT employee_id, first_name ||
> \' || last_name FROM t_employee ORDER BY
> LOWER(first_name) ASC';
> $rs_product = $db->Execute($sql_product);
> $rs_employee = $db->Execute($sql_employee);
> $db is true, but i don't think i'm connecting to the
> db. i can echo text prior to the transaction, but i
> can't echo anything after the transaction. i
> the transaction and just left the Execute statements
> same problem.
> does anyone have any idea why this isn't working?
upon further review, it appears my users and groups
didn't survive the backup and restore procedure since
pgsql 8.1 is looking for group roles and login roles.
even so, i don't understand why postgres (a current
login role) is not connecting to the db.
i will try and mimic my prior setup and go from there.
Yahoo! Mail - PC Magazine Editors' Choice 2005
In response to
pgsql-novice by date
|Next:||From: Jaime Casanova||Date: 2005-11-14 19:04:21|
|Subject: Re: Problem Connecting to DB After 8.1 Upgrade|
|Previous:||From: operationsengineer1||Date: 2005-11-14 18:20:12|
|Subject: Re: Application using PostgreSQL as a back end (experienced programmers please)|