I have read, and tried, many solutions and am running out of ideas.

My web server is processing my PHP pages, but won't connect to my Oracle DB. Every time I try to connect to my database I get the same error: Warning: ocilogon(): _oci_open_server I have the correct extension un-commented and my extensions are where my PHP.INI file expects them.

Help!

Web Server: W2K, IIS, PHP V 4.3.3
DB Server: W2K, Oracle 9.2 (seperate from Web Server)

putenv("ORACLE_SID=RIMSDev");

putenv("ORACLE_HOME=desert121\ora92");
// I created a share on the db server called ora92
$db = "(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = desert121)(PORT = 1521) ) )
(CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = RIMSDev.FRTC) ) )";
$conn = OCILogon("scott", "tiger", "RIMSDev");

    For the sake of others, let me post my solution.

    I discovered my symptoms were rooted in NTFS file permissions. I was logging into my desktop machine with a domain account, which did not have sufficient permissions to access the files I needed. The OCILogon command doesn't produce errors, so I never thought to look there. I haven't yet identified the minimum permissions necessary and to which folders, I simply added my domain account to the local administrator's group of the web server. After doing so, all my problems went away.

    Granted, this is not a solution I can apply to every user but at least I'll know where to start.
      Write a Reply...