Re: oracle 92 / IIS / windows
| From: | Philippe Saladin | Date: | Wed, 21 May 2003 06:07:38 +0000 |
| Subject: | Re: oracle 92 / IIS / windows | ||
| References: | 1 2 | Groups: | php.db php.general php.windows |
| Request: | Send a blank email to php-db+get-27939@lists.php.net to get a copy of this message | ||
"Catalin Trifu" <catalin@isp-software.de> a écrit dans le message news:
20030520154319.99181.qmail@pb1.pair.com...
...
> I also think you have to make sure you supply the correct parameters
to
> the
> OCILogon function
> especially the database parameter.
> It has to be a name from tnsnames.ora
> For instance:
> lets's say you have in tnsnames.ora:
> CONN.LOCAL =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = ORCL)
> )
> )
>
> If I remember correctly you would have to connect like this:
> $conn = OCILogon("scott", "tiger", "CONN.LOCAL");
Or directly
$conn = OCILogon("scott", "tiger", " (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
)
)
");
(I've trouble using the name defined in tnsnames.ora, I don't know exactly
why, probably a problem with environment variable. Anyway, this workaround
works in my case).
Regards,
Philippe