Re: Connecting PHP to Oracle9i

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



This is what I am using to get connected to 8i 8.1.7.4.0.  The $db section is copied right out of the TNSNAMES.ORA file, once Oracle Client has been installed and setup on the local machine.
 
Now that I am connected, I'm having a hard time getting my query to return using OCIPARSE().  I am getting "Wrong parameter count for ociparse()".  Anyone have any ideas on this?
 
Thanks for any help. - Paul
 
function db_connect()
{
$username = "dw_val";
$password = "dw_val";
$db="(DESCRIPTION=
          (ADDRESS_LIST=
            (ADDRESS=(PROTOCOL=TCP)
              (HOST = **name or i.p. address**)(PORT=1521)
            )
          )
          (CONNECT_DATA=(SERVICE_NAME=**FQDN**))
     )";
$conn = OCILogon($username,$password,$db);
if (!$conn)
{
   echo "Connection failed";
   echo "Error Message: [" . OCIError($conn) . "]";
   exit;
}
else
{
  echo "Connected!";
}
}
-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux