PHP 5.2.5
IIS 5.1 (Although on the production machine it will be IIS 6.0)
Oracle 10.2.0.1 Express Edition (On the production machine: Oracle Enterprise 10g)
Hello,
Ok, first my final goal - I'm trying to get phpBugTracker running using the Oracle Database that we already have as a back-end. If anyone knows an easier way to do it or suggestions for other software to use by all means recommend me.
What I've down so far:
Downloaded and ran the PHP installer from http://www.php.net/downloads.php
Installed the DB and OLE package for pear, hear is pear list:

PACKAGE          VERSION STATE
Archive_Tar      1.3.2   stable
Console_Getopt   1.2.3   stable
DB               1.7.13  stable
OLE              0.6.1   beta
PEAR             1.6.1   stable
Structures_Graph 1.0.2   stable

I can get php scripts that do not reference the database to run both through the web server and through php.exe on the command line.
However, I cannot for the life of me get pear.db working. And I get different errors depending on whether I run it by accessing the server or from the command line
Here is my test program:

<?php
if(!include_once('DB.php'))  println('Include Failed');
else println('Include Suceeded!');
$db = DB::Connect('oci8:scott:tiger@XE');
if(DB::isError($db)) println('Msg: '.$db->message);
else println('Connection Succeeded!');

function println($str) {echo($str.'<br/>\n');}
?>

Command Line Output:

> php test.php
Include Suceeded!
Msg: DB Error: not found

Output when accessed through a browser:

Warning: include_once(DB.php) [function.include-once]: failed to open stream: No such file or directory in C:\Documents and Settings\georgem\My Documents\projects\test\test.php on line 2

Warning: include_once() [function.include]: Failed opening 'DB.php' for inclusion (include_path='.;C:\php5\pear') in C:\Documents and Settings\georgem\My Documents\projects\test\test.php on line 2
Include Failed
Fatal error: Class 'DB' not found in C:\Documents and Settings\georgem\My Documents\projects\test\test.php on line 8

I should mention that I ran go-pear.php so my php.ini file contains the line

;***** Added by go-pear
include_path=".;C:\Program Files\PHP\pear"
;*****

Oh, and I've checked permissions. The user being used by IIS for that website should have full permissions to the PHP and all subdirectories

Any ideas? Please hlep!

    ok, resolved the issue of the outputs being different by setting the phprc enviroment variable to "C:\Program Files\PHP\"
    Still getting the DB Error message though

      Write a Reply...