[SOLVED] Re: PHP+Oracle: could not resolve service name

Álvaro G. Vicario escribió:
> My issue is that PHP scripts cannot connect to the database server when
I 
> run them from the *command line*. I get this error message:
> 
>     SQL error: [Microsoft][ODBC driver for Oracle][Oracle]ORA-12154:
TNS:no 
> se ha podido resolver el nombre del servicio, SQL state 08001 in
SQLConnect
> 
> Which translates into English as "could not resolve service name".
> 
> The *very same code* runs fine when parsed through the web server
(Apache2 + 
> PHP module running as LocalSystem) and I've found no problems using
TOAD. 
> Apart from environment, PHP configuration is identical in command line
and 
> web.

Oh my... I've fixed it. I had to strip Windows line feeds out of 
"TNSNAMES.ORA" and "SQLNET.ORA" and replace them with Unix ones!

http://www.phpbuilder.com/lists/php-db/2001051/0192.php

GRMFFF@[EMAIL PROTECTED]
 is there an easy way to specify my own files for this application? 
Now it works, I don't want it broken the day any sysadmin edits the file.