Access to Oracle works from localhost, but not live server

[pablogosse]

Hi all. I'm about to start developing a PHP site with an Oracle backend, and we're having some trouble getting things working on a live server.

Presently on my local machine (Win2K) I'm running PHPDev, and when I access the database via a script running on localhost, it works fine. However, when I access it from a linux server (http://pablo.unbc.ca/ora_test.php) I'm not getting any results back.

All I get is the first debug statement from ADOdb:
code: select table_name from cat where table_type in ('TABLE','VIEW')[/code]and nothing after that, not even the simple echo statement.

Here's the code:

<?php
include_once('_classes/adodb/adodb.inc.php');
$conn = &ADONewConnection('oci8');
$conn->Connect('*server*','*user*','*pass*','*dbname*');
$conn->debug = true;
$tables = $conn->MetaTables();
echo "entering loop...<br><br>";
while (list(,$val) = each($tables)) {
	echo '<strong>'.$val.'</strong><br>';
	$cols = $conn->MetaColumns($val);
	while (list(,$b) = each($cols)) {
		$vars = get_object_vars($b);
		while (list($x,$y) = each($vars)) {
			echo $x == 'name' ? '<br>&nbsp;&nbsp;&nbsp;<strong><em>'.$y.'</em></strong><br>' : '';
			echo $x != 'name' ? '&nbsp;&nbsp;&nbsp;<em>'.$x.' = '.$y.'</em><br>' : '';
		}
	}
	echo '<br>';
}
?>

I'm using ADOdb for my connections, and the database if Oracle 9.1. This link shows the results as they appear when I run the page through localhost:

http://pablo.unbc.ca/localhost_results.html

It's very strange to me, since as you can see by the ADOdb debugging, the first query is executing, but everything after that, even the line that just prints 'entering loop...' is not working.

Again, the script works fine on my localhost, as you can see from the url above.

Does anyone have any idea what could be causing this?

Thanks in advance,
Pablo