For Programmers: Free Programming Magazines  


Home > Archive > PHP Documentation > April 2006 > #37110 [Opn->Csd]: Docs for PDO_OCI DSN









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author #37110 [Opn->Csd]: Docs for PDO_OCI DSN
vrana@php.net

2006-04-26, 7:58 am

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
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com