Oracle 8i and PHP4 on the same NT machine

Anon

I have on my server :
Windows NT 4 SP4
Oracle 8i Enterprise Edition
Apache 1.3.12
PHP 4.0.1pl2 with php_oci8.dll

I've tried to connect via PHP with a script like this :

$db = "apache";
$c1 = ocilogon("apache","apache",$db);
, where $db= "apache" is a name created with Net8 Easy Config.
The d:\oracle\ora81\network\admin\tnsnames.ora file containes:

APACHE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.187)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = banca)
)
)
and "banca" is the Global Database name.

The error i'm getting is :

Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name
in c:\apache\htdocs\oracle.php on line 8

I added the following lines in my php script :

putenv("ORACLE_HOME=d:\oracle\ora81");
putenv("LD_LIBRARY_PATH=d:\oracle\ora81\lib");

and I get the same error.

PLEASE HELP ME ...

Anon

does ur SQLPlus work ??
have u tried connecting to oracle using SQLPlus giving user/password/connectstring
as apache/apache/apache ???
what result does it give ???

Anon

Yes. apache/apache/apache will connect with no problem :

"Connected to:
Oracle8i Release 8.1.5.0.0 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production

SQL>_
"

Anon

You may wish to make certain that the user under which apache is running has proper permissions for your tnsnames.ora file.

Anon

I'm having the same problem, only Oracle on another machine. Sql Plus and tnsping connects fine.
You may try:

ocilogon($user, $pw, "(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.187)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = banca)
)
)");

Didn't work for me though =(
Let me know when you got it working!

Anon

I can get a "slightly better error" by doing this :

$dbcnn = ocilogon("scott@database", "tiger");

rather than

$dbcnn = ocilogon("scott", "tiger", "database");

I obtain

ORA-12203: TNS:unable to connect to destination

which means that at least the tnsnames.ora file is reached.

ok, it doesn't work... but it is maybe a step forward ?