Connecting to oracle 9i using php

Bengal313 · 11-03-2003, 07:09 PM

I am using php 4.3.2, apache 2, oracle 9i, and everything is running on linux Suse. I created a connection to oracle using php and the connection wizard in dreamweaver mx. I got the connection to work using php-adodb server model. But I am getting a weird problem. After I get the connection to create successfully, and create a recordset, after a few minutes the connection fails. It seems that apache hangs up the connection or something. I have to go into apache 2.0 and restart it. Them it comes back again. And the same thing happens again. Any thoughts.

PASHA_SANYAL · 11-05-2007, 06:08 AM

Hi Bengal313,
How r u connecting to the oracle through php and adodb. I am myself connecting to remote oracle with the following code. Can you tell me what's going wrong. I am not being able to connect to the oracle.

Code:

$DSN="oci8://".USERNAME.":".PASSWORD."@".HOST."/".SID;
$DB=NewADOConnection($DSN);
$DB->debug = 1;

Then I am using this code:

Code:

$res	=	$DB->Execute($sql) or die($DB->ErrorMsg());

It is showing error:
Fatal error: Call to undefined method stdClass::Execute()

I would be greatly obliged if you can share me some light on this...

Thanks in advance,