Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Connect web service run on IIS to remote Oracle db using 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
-
- Check the PHP & IIS logs to find out what the actual PHP problem is.
- Review https://blogs.oracle.com/opal/entry/how_to_use_iis_php_and_oracle