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!

« previous php.pear.general (#9091) next »