Thread: PHP VS Oracle
View Single Post
 
Old June 15th, 2004, 10:52 PM
junemo junemo is offline
Authorized User
 
Join Date: Apr 2004
Location: malacca, malacca, Malaysia.
Posts: 69
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to junemo
Default

<?php
require_once 'DB.php'; //require the PEAR::DB classes.

$db_engine = 'oci8';
$db_user = 'prod';
$db_pass = 'prod';
$db_host = 'ptmn';
$db_name = 'prod';

$dsn = $db_engine.'://'.$db_user.':'.$db_pass.'@'.$db_host.'/'.$db_name;

$db = DB::connect($dsn, TRUE);
/* assign database object in $db_object, if the connection fails $db_object will contain
the error message. */

// If $db_object contains an error print out the
// error and exit.

if(DB::isError($db)) {
    die($db->getMessage());
}

$db->setFetchMode(DB_FETCHMODE_ASSOC);

$db->disconnect(); // Close the connection.

?>

I get this error msg:
DB Error: unknown error

What solution can I do?

Thanks in advance.