Can't connect to Oracle
| From: | Herbert Groot Jebbink | Date: | Mon, 12 Mar 2001 16:48:04 +0000 |
| Subject: | Can't connect to Oracle | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-5970@lists.php.net to get a copy of this message | ||
Hi,
I can't connect from a win95/Apache setup to a Oracle database
- The PHP version is 4.04pl1 (Nusphere)
- The location for tnsnames.ora is c:\orawin95\network\admin\tnsnames.ora
- De Oracle version is 7.3.4.0.0
- De SQL*NET client version is 2.3.4.0.0
- Using the SQL PLUS 3.3 client on this machine works fine:
- The Oracle module is active in php.ini
The test program:
<?php
putenv('ORACLE_HOME=c:\orawin95');
putenv("ORACLE_SID=WKDS");
$conn = ora_plogon("hgj@wkds", "hgj");
?>
The result:
Warning: Unable to connect to ORACLE (ORA-12154: TNS:could not resolve
service name) in /www/data/ontwikkel/test/php/test3.php on line 5
Someone a idea whats wrong?
Greetings, Herbert
--
The Trans-Siberian Railroad Page: http://herbert.groot.jebbink.nl