note 11528 added to OCILogon
| From: | tabish_mohd at yahoo dot com | Date: | Fri, 23 Feb 2001 13:45:30 +0000 |
| Subject: | note 11528 added to OCILogon | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-11475@lists.php.net to get a copy of this message | ||
After long research we done it:
the error is:
Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name.
OR
Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name
By setting the envornment variable doesn't work.(putenv(ORACLE_SID=TNSNAME");
now the solution is:
put the tnsname.ora contents into the variable as,
$db="(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = RemoteServerIP)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))
)";
OCILogon("scott","tiger",$db);
now it will work.
http://www.php.net/manual/en/function.ocilogon.php