oci8 dsn
| From: | " | Date: | Sun, 23 Nov 2003 13:38:09 +0000 |
| Subject: | oci8 dsn | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-9091@lists.php.net to get a copy of this message | ||
I am trying to connect an Oracle 8i server on linux. I am using the example code in the DB
documentation, but I keep getting the following message: "DB Error: Connect failed" .
Oracle & Apache/PHP/Pear all reside on the same machine.
Here is my dsn string where "oralin" is my oracle SID name, user name is "paul"
and the password is "password".
$dsn ="oci8://paul:password@localhost/oralin";
I have also tried the following with the same result:
oci8://paul:password@zoot.cem.va.com/oralin.cem.va.com
oci8://paul:password@tcp+zoot.cem.va.com:1527/oralin.cem.va.com
However, I am able to connect with the regular PHP OCI8 like this:
$connection=OCILogon("paul", "password", "oralin");
Is there something wrong with my dsn string? Or perhaps a problem with tnsnames.ora?
Many Thanks for your help.
_______________________________________________
Join Excite! - http://www.excite.com
The most personalized portal on the Web!