PHP OCI interface not working

-----BEGIN PGP SIGNED MESSAGE----- Hi, I'm trying to get PHP with the OCI interface to oracle working on a system. I have it working on one system, but when I set it up exactly the same on a different system, it fails. The oracle client is installed, and I have the perl DBI module working properly on both systems. This is on a RedHat 6.2 system with Oracle 8.1.6.1 and Apache 1.3.12 installed The php module I'm executing is: <?php $conn = OCILogon("dldb", "dldb123","devdb1"); $s="select count(*) from survey"; $stmt=OCIParse($conn,$s); OCIExecute($stmt); OCIFetchInto($stmt,&$line); OCIFreeStatement($stmt); print "count of survey is $line[0]"; ?> Amd I'm getting the following errors via the web browser: Warning: _oci_open_server: Error while trying to retrieve text for error ORA-12154 in /home/httpd/html/test_db.php on line 2 Warning: Supplied argument is not a valid OCI8-Connection resource in /home/httpd/html/test_db.php on line 4 Warning: Supplied argument is not a valid OCI8-Statement resource in /home/httpd/html/test_db.php on line 5 Warning: Supplied argument is not a valid OCI8-Statement resource in /home/httpd/html/test_db.php on line 6 Warning: Supplied argument is not a valid OCI8-Statement resource in /home/httpd/html/test_db.php on line 7 co there is nothing in the log files to indicate what is wrong. Any idea what is going on? The only difference between these two systems is their location, one is external to the network, the other is internal. Thanks in advance. JBB - -- ICQ # 44910403 Power Listviewer URL: http://www.bigfoot.com/~PowerListviewer PMMail Archiver URL: http://www.bigfoot.com/~Jonathan_Bayer/archiver For PGP Public key block/Fingerprint send the following message to me as the Subject: Send PGP Signature -----BEGIN PGP SIGNATURE----- Version: PGPsdk version 1.7.1 (C) 1997-1999 Network Associates, Inc. and its affiliated companies. iQCVAwUBOjVFK41F3x2FJJilAQH8JgQAsB84QYi8i0WsBWNZA0ZrDQmslXy4FD5p HFjMM81xFOrJCAFI5794yGF0PAuC5eZG12eahSp79/Lalv97/FDRK2tzV8mvpsU2 Mej5hZooRedDpZZfv/OdvMvx6GOs4mBSHpBrav6Y27UtQIjU00bRh3iITgLuQeCh uY83/5Qjnek= =SLXf -----END PGP SIGNATURE-----