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

ID: 25688 Updated by: sniper@php.net Reported By: ramez at faraah dot com dot sa -Status: Open +Status: Bogus Bug Type: OCI8 related Operating System: Win XP PHP Version: 4.3.1 New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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