var $default = array(
'driver' => 'adodb',
'connect' => 'oci8',
'host' => '',
'login' => 'username',
'password' => 'password',
'database' => 'dbname',
'prefix' => ''
);
I found that the major issue that I had was placing a host name in the
array. You should leave it blank.
Use this script to test if your Oracle/PHP configuration is working:
<?php
$conn = oci_connect('username', 'password', 'dbname');
oci_connect(
if (!$conn) {
$e = oci_error();
print htmlentities($e['message']);
exit;
}
$query = "SELECT 'hello' FROM DUAL";
$stid = oci_parse($conn, $query);
if (!$stid) {
$e = oci_error($conn);
print htmlentities($e['message']);
exit;
}
$r = oci_execute($stid, OCI_DEFAULT);
if (!$r) {
$e = oci_error($stid);
echo htmlentities($e['message']);
exit;
}
print '<table border="1">';
while ($row = oci_fetch_array($stid, OCI_RETURN_NULLS)) {
print '<tr>';
foreach ($row as $item) {
print '<td>'.($item?htmlentities($item):' ').'</td>';
}
print '</tr>';
}
print '</table>';
oci_close($conn);
?>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
