[PHP-DB] Re: Help with oci dll in PHP

[Philippe Saladin]

> Warning: ocilogon
> (): _oci_open_server: Error while trying to retrieve
> text for error ORA-12538 in c:\inetpub\wwwroot\php\index.php on line 15

ORA-12538 means "TNS : no such protocol"

- you have a problem in your TCP protocol ?
- or there is a typo error in your line :
> $db = " (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)
> (HOST =192.168.1.9) (PORT=1521)) (CONNECT_DATA = (SERVICE_NAME=test1))) ";

Here is what I use in my case :
$db="
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = <ip_address>)
          (Port = 1521)
        )
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = <ip_address>)
          (Port = 1526)
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
";

Note the difference in CONNECT_DATA. Would it come from that ?

Hope it will help.

Regards,
Philippe



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php