#37110 [Opn->Csd]: Docs for PDO_OCI DSN

ID: 37110 Updated by: vrana@php.net Reported By: crescentfreshpot at yahoo dot com -Status: Open +Status: Closed Bug Type: Documentation problem Operating System: Irrelevant PHP Version: 5.1.2 New Comment: This bug has been fixed in the documentation's XML sources. Since the online and downloadable versions of the documentation need some time to get updated, we would like to ask you to be a bit patient. Thank you for the report, and for helping us make our documentation better. Previous Comments: ------------------------------------------------------------------------ [2006-04-17 19:06:10] crescentfreshpot at yahoo dot com re-categorized: docs problem not pdo problem ------------------------------------------------------------------------ [2006-04-17 19:04:44] crescentfreshpot at yahoo dot com Referring to: http://www.php.net/manual/en/ref.pdo-oci.connection.php ------------------------------------------------------------------------ [2006-04-17 19:03:46] crescentfreshpot at yahoo dot com Description: ------------ The docs state "If you are connecting to a database defined in tnsnames.ora, append the name of the database to the DSN prefix and your DSN is complete." However on php 5.1.2 i've had to append 'dbname=' first to get it to work. E.g. (my database name is 'prod'): <?php // should work according to docs but fails $dbh = new PDO('oci:prod', 'user', 'pass'); /* fails with ORA-12560: TNS:protocol adapter error */ // This works: $dbh = new PDO('oci:dbname=prod', 'user', 'pass'); ?> ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=37110&edit=1