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

ID: 25688 User updated by: ramez at faraah dot com dot sa Reported By: ramez at faraah dot com dot sa -Status: Bogus +Status: Open Bug Type: OCI8 related Operating System: Win XP -PHP Version: 4.3.1 +PHP Version: 4.3.3 New Comment: Hello i try to use PHP4.3.3 but the same problem happen again.... The Oracle9i comes with Apache but i have in my computer IIS i try To connect to Oracle DB in IIS using PHP4.3.3 i stoped the apache service Previous Comments: ------------------------------------------------------------------------ [2003-09-29 08:29:23] sniper@php.net And try searching for ORA-12560 with Google for example.. ------------------------------------------------------------------------ [2003-09-29 08:28:16] sniper@php.net Thank you for taking the time to report a problem with PHP. Unfortunately you are not using a current version of PHP -- the problem might already be fixed. Please download a new PHP version from http://www.php.net/downloads.php If you are able to reproduce the bug with one of the latest versions of PHP, please change the PHP version on this bug report to the version you tested and change the status back to "Open". Again, thank you for your continued support of PHP. We\'re at PHP 4.3.3 already. ------------------------------------------------------------------------ [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