Re: Adodb

[Chris Thompson]

    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):'&nbsp;').'</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 cake-php@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---