loading fastCGI modules in windows ultimate |
- Click Start, and then click Control
Panel.
- In Control Panel, click Programs,
and then click Turn Windows features on or off.
- In the Windows Features dialog box, click
Internet Information Services to install the
default features, and then select the following additional
feature in the Application Development Features
section:
- Click OK to close the Windows
Features dialog box.
|
Let us open
Note fastCGI modeis installed.
|
Let us add php using handler mapping application
Click on "Add Module Mapping"
PHP is added
|
|
|
|
|
The most of the time incorrect network configuration can pose some
errors like this one; " oci_connect(): ORA-12514: TNS:listener does not
currently know of service requested in connect descriptor."
I had seen few of those in the past with oracle 8.0, I was
care full. I would like
to present one set of configuration scripts, which worked for me.
Please note, 11.2 XE , the scripts were different. In this workstation,
the default the service name was "orcl.gateway.2wire.net".
# tnsnames.ora Network Configuration File:
#C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.gateway.2wire.net)
)
)
|
# listener.ora Network
Configuration File:
#C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
ADR_BASE_LISTENER = C:\app\Administrator
|
Testing
:
<?php
// Connects to the XE service (i.e. database) on the "localhost"
machine
$conn = oci_connect('hr', 'Son', 'localhost/orcl.gateway.2wire.net');
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
echo" DB connected: querying a table <br/>";
$stid = oci_parse($conn, 'SELECT * FROM employees');
oci_execute($stid);
echo "<table border='1'>\n";
while($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) {
echo "<tr>\n";
foreach ($row as $item) {
echo "<td>".($item !== null ? htmlentities($item, ENT_QUOTES):" ")."</td>\n";
} //foreach ends
echo "</tr>\n";
}//while block ends
echo "</table>\n";
?>
|
|
|