note 63958 rejected from ref.pdo-oci.connection by bjori
| From: | bjori@php.net | Date: | Tue, 04 Apr 2006 18:07:35 +0000 |
| Subject: | note 63958 rejected from ref.pdo-oci.connection by bjori | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-107314@lists.php.net to get a copy of this message | ||
Note Submitter: crescentfreshpot at yahoo dot com
----
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 on windows 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');
?>