Hi Miguel,
try
>if(!($conn=ora_logon("user","pass","SERVICE")))
it always works for me
HTH
Steve
At 10:47 PM +0100 3/5/01, Miguel wrote:
>Hi,
>
>I'am having serious problems in put php acessing a remote oracle 8 database,
>i have tried several configurations but always end up with
>
>Oracle: Connection Failed: ORA-12154: TNS:could not resolve service name in
>/var/www/htdocs/support/teste.php on line 5
>
>I can access this database from sqlplus and when I start apache all oracle
>variables are set. If I get rid of the connect string and access my local
>database then everything is ok.
>
>My code is something like...
>
>putenv("ORACLE_HOME=/apps/oracle/8.1.7");
>putenv("TNS_ADMIN=/apps/oracle/8.1.7/network/admin");
>
>// main
>if(!($conn=ora_logon("user@SERVICE","pass")))
>
>echo "Error: Cannot connect to database\n";
>exit;
>}
>
>....
>
>Using:
>
>apache: apache_1.3.19
>php4: php-4.0.5
>Linux: Red Hat 7.0 with latest patch's
>Remote Oracle DB: Oracle 8.1.6 W2K
>Local DB: Oracle 8.1.7 Linux
>
>php build with: --with-oci8 --with-oracle
>
>Any help would be apreciated...
>
>Thanks,
>Miguel
>
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
---------------------------------------------------
"Minds are like parachutes, they work best when open"
Support free speech; visit http://www.efa.org.au/
Heads Together Systems Pty Ltd http://www.hts.com.au
Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
