2. PHPRunner General questions
  3. Oracle
This topic is locked

Oracle

 		3/9/2006 8:13:58 AM
PHPRunner General questions
hfg author

I am having trouble getting my php generated by phprunner (3 beta) to work. I have Oracle 9.2 running on one server and a second server with IIS on it where the php resides. When I access the created pages they come up blank with no errors.
If I view the source I get this:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML><HEAD>

<META http-equiv=Content-Type content="text/html; charset=windows-1252"></HEAD>

<BODY></BODY></HTML>
I am able to run php pages from my mySQL DB (which is on the IIS server).
What do I need to do in order to get the php pages to pull the Oracle data? I have the Oracle Client on the IIS server along with the proper ODBC setup. On my workstation (setup with the same client and ODBC) I can connect to the Oracle DB in order to create the pages.
Any advice or help would be very helpful, thanks
Sergey Kornilov admin 3/13/2006

Hi,
some older PHPRunner versions suppress Oracle error output.

Please install the latest PHPRunner update available at:

http://www.asprunner.com/files/phprunner-setup.exe
Then rebuild your project.

PHP page will display the error message.
The most frequent error is inadequate PHP configuration to work with Orace.

You should uncomment this line in C:\Windows\php.ini file:

;extension=php_oci8.dll

Then restart IIS.
hfg author 3/13/2006

I upgraded to 3 and recomplied. This is the error I got upon trying to view the new page:
Fatal error: Call to undefined function: oci_fetch_array() in C:\inetpub\wwwroot\mis\amsrpts\include\dbconnection.php on line 32
The php_oci8.dll extention is already setup.
Thanks for the help
Sergey Kornilov admin 3/15/2006

Hi,
PHPRunner-created pages work with Oracle under PHP5 only.

We plan to add PHP4 Oracle support in one of next updates of PHPRunner.