I've had exactly the same problem, so will be very interested in an answer too. I have 
spent (wasted) a lot of time trying to resolve it myself, using every variant on every 
variable I could imagine. I decided it might be a win95 problem, as the same setup 
works on win98.

-----Original Message-----
From: Herbert Groot Jebbink [mailto:[EMAIL PROTECTED]]
Sent: 12 March 2001 16:48
To: [EMAIL PROTECTED]
Subject: Can't connect to Oracle


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 


**************************************************************************
Any opinions expressed in this email are those of the individual and 
not necessarily the Company. This email and any files transmitted with 
it, including replies and forwarded copies (which may contain alterations) 
subsequently transmitted from the Company, are confidential and solely for 
the use of the intended recipient. If you are not the intended recipient 
or the person responsible for delivering to the intended recipient, be 
advised that you have received this email in error and that any use is 
strictly prohibited.

**************************************************************************

-- 
PHP Windows 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]

Reply via email to