RE: Can't connect to Oracle

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:hgj@xs4all.nl] Sent: 12 March 2001 16:48 To: php-windows@lists.php.net 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. **************************************************************************