DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Connect web service run on IIS to remote Oracle db using PHP

f326a661-8cb2-4cb0-9db3-1287fc2b7e79Feb 16 2016 — edited Feb 21 2016

I am trying to connect to a remote oracle database from an IIS machine using PHP. Starting very basic my code is

<!DOCTYPE html>

<?php

if ($conn = oci_connect(username, passowrd, server:port/instance')
{
    echo 'Successfully connected to Oracle Database!';
}
else
{
     $errmsg = oci_error();
     echo 'Oracle connection failed' . $errmsg['message'];
}
?>

I can connect to the oracle db using sql developer and the command prompt. But every time I attempt a connection using this code I get an Http 500 error.

I can run a basic html and PHP page on the machine.

any help to start me on the proper path is great.

I have oracle instant client installed: c:\oracle\instantclient_12_1\

I have oracle PHP installed: c:\Program Files (x86)\PHP\5.6\

My website and PHP code is located at: F:\ inetpub\wwwroot\

Thanks, wil

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 20 2016

Added on Feb 16 2016

#php

1 comment

2,550 views