Re: PEAR::MDB connecting to remote Oracle-DB

Phillip Oertel wrote:

is there anything i have to do differently to make it work with the abstraction? looking at the MDB_oci8 code doing the connect, it seems that the DBNAME has been chopped away from the server-ip, and only the server-ip is being used for the ORACLE_SID. i think that is the difference in the two attempts.

yes .. this is somewhat non obvious non documented. the cause if the problem is that oracle lacks the same kind of concept as other rdbms have for grouping tables (see this bug report for detail http://pear.php.net/bugs/bug.php?id=2532). in mdb2 i have made this optional. so what do you have to do? the database name is actually used as the username you can specific the sid using the hostspec

    $dsn => array(
        'phptype' => 'oci8',
        'database' => '[name of the database]',
        'password' => 'foobar',
        'hostspec' => '[SID]',
    );

hope i am remember this correctly .. let me know if you have problems. regards, Lukas