* Mitchel, Jennifer (Jem) <[EMAIL PROTECTED]> [2002-12-17 04:19]:
> Hi all,
>
> I am getting the following error out of a script.
> DBI->connect(carespro) failed: ORA-12154: TNS:could not resolve
> service name (DBD ERROR: OCIServerAttach) at test.cgi line 11 Can't
> call method "prepare" on an undefined value at test.cgi line 16.
>
> I am sure the tnsnames entry is correct because i can use sqlplus
> and connect. I am positive i have the sid, username, and password
> correct.
>
> Interesting if I take this code and put it on the machine where the
> db i'm trying to connect is... it works ok.
>
> Has anyone ever seen that? Does anyone know what I can do about it?
It sounds like the DNS name of the server you are referencing in the
connect() can't be found.
You are checking the return value of connect(), right?
my $dbh = DBI->connect($dsn, $user, $pass, $attr)
or die $DBI::err;
(darren)
--
Once you eliminate the impossible, whatever remains, no matter how
improbable, must be the truth.
-- Sherlock Holmes
