#25688 [Csd->Bgs]: Connect To Oracle 9i using IIS & PHP

ID: 25688 Updated by: didou@php.net Reported By: ramez at faraah dot com dot sa -Status: Closed +Status: Bogus Bug Type: OCI8 related Operating System: Win XP PHP Version: 4.3.3 New Comment: Please leave this bug bogus. Previous Comments: ------------------------------------------------------------------------ [2003-09-30 05:25:45] ramez at faraah dot com dot sa i found the solution i should write the Service name In The Connection Function ============================================== $c1 = ocilogon("scott","tiger","RamezDB") or print("<br>Could not connet to Oracle9i<br>"); ============================================== thanks for your help ------------------------------------------------------------------------ [2003-09-29 08:29:23] sniper@php.net And try searching for ORA-12560 with Google for example.. ------------------------------------------------------------------------ [2003-09-29 08:25:05] ramez at faraah dot com dot sa Description: ------------ Hello I am using Oracle9i release 2 it's comes with Apache but i am using IIS and i don't want to use Apache. how can i connect to Oracle DB from the IIS using PHP i try to use ================= user:scott Password:tiger Service:RamezDB ================= how can i do ti Reproduce code: --------------- <HTML> <HEAD> <TITLE>Using PHP to Read a Table in Oracle</TITLE> </HEAD> <BODY BGCOLOR="#FFFFFF"> <CENTER><B>Employees</B> <BR><BR> <?php $c1 = ocilogon("scott","tiger") or print("<br>Could not connet to Oracle9i<br>"); $stmt = ociparse($c1," select * from emp"); ociexecute($stmt,OCI_DEFAULT); echo $c1."----selecting\n\n"; while (ocifetch($stmt)) echo $c1." <".ociresult($stmt,"TEST").">\n\n"; echo $c1."----done\n\n"; Expected result: ---------------- to reterive the data from Oracle9i Actual result: -------------- Warning: _oci_open_server: ORA-12560: TNS:protocol adapter error in c:\inetpub\wwwroot\oracle\test.php on line 10 Could not connet to Oracle9i Warning: ociparse(): supplied argument is not a valid OCI8-Connection resource in c:\inetpub\wwwroot\oracle\test.php on line 13 Warning: ociexecute(): supplied argument is not a valid OCI8-Statement resource in c:\inetpub\wwwroot\oracle\test.php on line 14 ----selecting Warning: ocifetch(): supplied argument is not a valid OCI8-Statement resource in c:\inetpub\wwwroot\oracle\test.php on line 16 ----done ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=25688&edit=1