On Mon, Dec 16, 2002 at 02:54:01PM -0600, Mitchel, Jennifer (Jem) wrote:
> 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.
What is the value of $ENV{ORACLE_HOME} inside your script? tnsnames.ora
should be at "$ENV{ORACLE_HOME}/network/admin/tnsnames.ora".
Ronald
