Oracle

[colamart]

ho installato php su win XP
Ho decommentato le estensioni extension=php_oci8.dll
sto provando a connettermi un DB Oracle

?php
 $DB = "(DESCRIPTION =
          (ADDRESS = 
           (PROTOCOL = TCP)
           (HOST = prova)
           (PORT = 1527)
         )
         (CONNECT_DATA =
          (SID = ORAC)
         )
        )";

$c1 = ocilogon("username","PSW", $DB); ?> 

ma mi restituisce il seguente errore

Warning: ocilogon(): _oci_open_server:  in c:\inetpub\wwwroot\php\oracle.php on line 20

qualche idea?
ciao

[lordzoster]

http://www.phpbuilder.com/lists/php-db/2003052/0126.php

[colamart]

ho seguito le istruzioni...stesso errore....

[colamart]

altro problrma

<?php
$conn = OCILogon($login, $pwd , 'ORACLE');
$stmt = OCIParse($conn,"SELECT * FROM gaac_anag_1l WHERE GAAC_ID_PRG != 0 AND GAAC_ID_PRG <= 33 ");
OCIExecute($stmt);
print("<TABLE BORDER=1>\n");
print ("<TR ALIGN=LEFT VALIGN=TOP>");
$cols = OCINumCols($stmt);
   for ( $i = 1; $i <= $cols; $i++ ) {
       $column_name  = OCIColumnName($stmt,$i);
       print ("<TH>" . $column_name . "</TH>\n");
       }

while ( OCIFetch($stmt) ) {
        print ("<TR ALIGN=LEFT VALIGN=TOP>");
        $ncols = OCINumCols($stmt);
        for ( $i = 1; $i <= $ncols; $i++ ) {
               $column_value = OCIResult($stmt,$i);
               print ("<TD>" . $column_value . "</TD>\n");
          }
        }
print("</TABLE>\n");
OCIFreeStatement($stmt);
OCILogoff($conn);
 ?>

Warning: ocifetch() [function.ocifetch]: OCIFetch: ORA-01002: cursore non valido in c:\Apache\Apache\htdocs\oracle.php on line 29 

ormai ho perso ogni speranza...
ciao