Skip site navigation (1) Skip section navigation (2)

Problem Connecting to DB After 8.1 Upgrade

From: <operationsengineer1(at)yahoo(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Problem Connecting to DB After 8.1 Upgrade
Date: 2005-11-14 17:41:40
Message-ID: 20051114174140.25933.qmail@web33306.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
i have the following adodb code (which shouldn't be
too hard to figure out for those not familiar with
adodb):

$db = &ADONewConnection('postgres8');
$db->Connect('localhost','postgres','3mydata5','mydb');
if (!$db) die('Connection failed');
$db->debug = true;

$sql_product = 'SELECT product_id, product_number FROM
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';

$db->StartTrans();
$rs_product = $db->Execute($sql_product);
$rs_employee = $db->Execute($sql_employee);
$db->CompleteTrans();

$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 removed
the transaction and just left the Execute statements -
same problem.

does anyone have any idea why this isn't working?

tia...


		
__________________________________ 
Start your day with Yahoo! - Make it your home page! 
http://www.yahoo.com/r/hs

Responses

pgsql-novice by date

Next:From: operationsengineer1Date: 2005-11-14 18:20:12
Subject: Re: Application using PostgreSQL as a back end (experienced programmers please)
Previous:From: Steve CrawfordDate: 2005-11-14 16:36:20
Subject: Re: Application using PostgreSQL as a back end (experienced programmers please)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group