"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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
