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" .
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?