Re: ERROR ORA-12154 TNS: could not resolve the connect identifier specified

beta escribió:
> #### OUT put
> # php oraConnect.php
> AD_PRES President 20000 40000 <br>
> AD_VP Administration Vice President 15000 30000 <br>
[...]
> #### browser
> http://localhost/oraConnect.php
> Warning: ocilogon() [function.ocilogon]: ORA-12154: TNS:could not
> resolve the connect identifier specified in /opt/www/oraConnect.php on
> line 2

I once got the opposite problem (it worked in web but not in command line). The issue got fixed when I opened tnsnames.ora in a text editor and changed the style of line feeds from Windows to Unix (it was a Windows box, anyway). It sounds stupid but...

BTW, the function names you are using in your PHP code are deprecated. Rather than OCIExecute() use oci_execute(), etc. Also, do some error checking in your code. Don't let the script proceed till the end when it can't even connect to the database.

-- 
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://bits.demogracia.com
-- Mi web de humor al baño María: http://www.demogracia.com
--