Re:Problem connecting to the remote oracle using PHP and ADODB

Hi All,
I really need help on the following code :( . I'm 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.:confused:

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


Then I am using this 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,

$DB=NewADOConnection('oracle');
$db->Connect($host, $user, $password, $database);
$res = &$db->Execute($sql);

Explained here (http://www.databasejournal.com/sqletc/article.php/2222651)

$DB=NewADOConnection('oracle');
$db->Connect($host, $user, $password, $database);
$res = &$db->Execute($sql);

Explained here (http://www.databasejournal.com/sqletc/article.php/2222651)

This is ok when you are connecting to the local database but not the remote database. For remote database you must require the host and the SID. Without it the connection cannot happen. Anyway thanks for the posting, I really appreciate it. :thumbsup:

Hi all,

I really need some help on this. Can't anyone help me out on this?? :(