I'm not looking forward to this...  Due to circumstances beyond my control,
I will be forced into a similar configuration soon.

Try putenv("ORACLE_SID=WKDS.world");
If your sqlnet.ora does does not specify .world as the default domain, then
that may be the problem.

Was your TNSNAMES.ORA file ftp'd from somewhere to where it is now?
  If so, did you use the ascii or text mode option?

HTH

"Herbert Groot Jebbink" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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
>
> --
> PHP Database 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]
>



-- 
PHP Database 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