logo       

oci8 dsn: msg#00389

php.pear.general

Subject: oci8 dsn


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@xxxxxxxxxxxxxxx/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!

--
PEAR General Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise