Forum Stats

  • 3,838,771 Users
  • 2,262,398 Discussions
  • 7,900,755 Comments

Discussions

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

f326a661-8cb2-4cb0-9db3-1287fc2b7e79
edited Feb 21, 2016 6:27PM in PHP

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

Answers

This discussion has been closed.