ID: 25688
User updated by: ramez at faraah dot com dot sa
Reported By: ramez at faraah dot com dot sa
Status: Bogus
Bug Type: OCI8 related
Operating System: Win XP
PHP Version: 4.3.3
New Comment:
thanks man
Previous Comments:
------------------------------------------------------------------------
[2003-09-30 05:30:09] [EMAIL PROTECTED]
Please leave this bug bogus.
------------------------------------------------------------------------
[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] [EMAIL PROTECTED]
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
