Help! How to connect to Oracle 8 using php

[JediDan]

I'm trying to connnect to an Oracle 8 database using TNSNAMES, through the oci8 driver in php. I loaded (by removing the the php_oracle.dll and php_oci8.dll
libraries in the php.ini file. Here's the error I keep getting:

Fatal error: Call to undefined function: ocilogon() in c:\phpdev\

http://www\phptest.php

on line 9

This is the code:

<?
	putenv('ORACLE_HOME=mypath');
	$Oracle = OCILogon('USER','USER','DBNAME');
?>

The ORACLE_HOME path (changed here) is correct. What else needs to be done?

Any help is appreciated.

 

[robertfleder]

The key to making oracle work is that the web browser's environment should have the oracle variables set or you have to putenv() in the code. For portability purposes I like it either in a separate include()'ed file or in the shell environment when the browser is launched.

 

[kaveri00]

try this.

$conn = Ora_Logon("user@TNSNAME", "pass"
ora_open ($conn)