Description: ------------ Oracle's "Easy Connect" syntax works with MDB2's array DSN, but not the string form. To use Easy Connect, Oracle 10g client libs are required. The Easy Connect syntax is username/password@[//]host[:port][/service_name] e.g. sqlplus scott/tiger@//mymachine:1521/orcl Reproduce code: --------------- require_once 'MDB2.php'; // This works $dsn = array( 'phptype' => 'oci8', 'hostspec' => '//mymachine/orcl', 'username' => 'scott', 'password' => 'tiger', ); // This doesn't connect $dsn = 'oci8://scott:tiger@//mymachine/oracle'; $db = MDB2::connect($dsn); Expected result: ---------------- Successful connection Actual result: -------------- The connection fails and $db->getDebugInfo() gives: [Error message: it was not specified a valid Oracle Service Identifier (SID)] ** oci8:///frodo/oracle:xxx@//frodo/oracle

The service name typo in my example is not the cause of the problem. Even with "orcl" in the failure-case example, the connection does not succeed.

What if you try this: $dsn = array( 'phptype' => 'oci8', 'hostspec' => 'hostname', 'username' => 'scott', 'password' => 'tiger', 'database' => 'orcacle', );

Please reply, I will close this issue in 3 days. Thank you David

This bug still exists. The DSN parsing overwrites the username. Looking in _doConnect() in Driver/oci8.php, the DSNs oci8://hr:hr@localhost/XE and $dsn = array( 'phptype' => 'oci8', 'hostspec' => 'hostname', 'username' => 'scott', 'password' => 'tiger', 'database' => 'XE', ); were previously both parsed with username set to XE, hostspec set to localhost and database set to false. (BTW, protocol is set to "tcp" with the former but not the latter code) Workaround: This array DSN connects correctly: $dsn = array( 'phptype' => 'oci8', 'username' => 'hr', 'password' => 'hr', 'hostspec' => '//localhost/XE' );

This bug has been fixed in CVS. If this was a documentation problem, the fix will appear on pear.php.net by the end of next Sunday (CET). If this was a problem with the pear.php.net website, the change should be live shortly. Otherwise, the fix will appear in the package's next release. Thank you for the report and for helping us make PEAR better.

the fix breaks sqlite DSN: sqlite:////full/unix/path/to/file.db?mode=0666 now parsed as: Array ( [phptype] => sqlite [dbsyntax] => sqlite [username] => [password] => [protocol] => tcp [hostspec] => //full/unix/path/to/file.db?mode=0666 [port] => [socket] => [database] => [mode] => ) previously it was: Array ( [phptype] => sqlite [dbsyntax] => sqlite [username] => [password] => [protocol] => tcp [hostspec] => [port] => [socket] => [database] => /full/unix/path/to/file.db [mode] => ) please reverse the changes. IMHO, parseURL() in MDB2.php is not broken. it is the oci8 driver that should rewrite MDB2 parsed DSN into oracle easy connect syntax if the underlying oci_connect() expects oracle easy connect syntax. in the mean time, the original submitter could use something like oci8://scott:tiger@%2F%2Fmymachine%2Forcl as workaround. i will try to get my hands into oracle driver very shortly.

Fixed in CVS, thanks.

my proposed fix to the oracle driver has been submitted as bug #10018