[Php-it] Oracle PDO

[Auri Mason]

Ciao

Oracle PDO:

#########################################################################
dato il TNSNAMES
#########################################################################
DEL1.DELSER.COM =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.1.5)(PORT = 1521))
     )
     (CONNECT_DATA =
       (SERVICE_NAME = del1)
     )
   )

#########################################################################
dato questo file di esempio
#########################################################################

<?php
   try {
     $dbh = new PDO('oci:dbname=10.0.1.5', 'fidesv45', 'fides');
   }
   catch (PDOException $e) {
     echo 'Connection failed: ' . $e->getMessage();
     exit;
   }

   $s = $dbh->prepare("SELECT GIAC_CODART, GIAC_QTA FROM  
GIACENZE_TRYME WHERE (((GIACENZE_TRYME.GIAC_CODMAG)='1' Or  
(GIACENZE_TRYME.GIAC_CODMAG)='1A')) and  
GIACENZE_TRYME.GIAC_CODART='0986'");
   $s->execute();
   while ($r = $s->fetch(PDO::FETCH_ASSOC)) {
     echo $r['GIAC_CODART'] . "<br>";
     echo $r['GIAC_QTA'] . "<br>";
   }
?>
#########################################################################

Qualcuno è in grado di indicarmi la corretta parametrizzazione?
Ottengo l'errore "Connection failed: SQLSTATE[HY000]:  
pdo_oci_handle_factory: ORA-12514: TNS:listener does not currently  
know of service requested in connect descriptor  
(/usr/src/php-5.1.2/ext/pdo_oci/oci_driver.c:463)"

Grazie mille, Auri