Connecting to Oracle
| From: | Herbert Groot Jebbink | Date: | Tue, 13 Mar 2001 15:41:28 +0000 |
| Subject: | Connecting to Oracle | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-7397@lists.php.net to get a copy of this message | ||
Hello,
I have problems connecting with PHP to Oracle.
- Operating system is Windows 95
- Apache version is 1.3.14
- The PHP version is 4.04pl1 (NuSphere 1.13.6)
- The line "extension=php_oracle.dll" is active in php.ini
- De Oracle Database version is 7.3.4.0.0
- De SQL*NET client version is 2.3.4.0.0
- Using the SQL PLUS 3.3.4.0.0 client on this machine works fine:
- The ociw32.dll file is in the path of the webserver
The test program is:
<?php
putenv('ORACLE_HOME=c:\orawin95');
putenv("ORACLE_SID=WKDS");
$conn = ora_logon("hgj@wkds", "hgj");
?>
The result is:
Warning: Unable to connect to ORACLE (ORA-12154: TNS:could not resolve
service name) in /www/data/ontwikkel/test/php/test3.php on line 4
I have lookup the ORA-12154 error and it talks about the tnsnames.ora
file, this file is located in c:\orawin95\network\admin\ and I have set
ORACLE_HOME to c:\orawin95, so it must find that file, the part
of the database in tnsnames.ora is below.
wkds.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = rnwux1)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = rnwux1)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = WKDS)
)
)
Greetings, Herbert