Why even use DBD::ODBC?
Why not use DBD::Oracle?
Cheers
John
> Subject: Re: DBD::ODBC fails, SQL*Plus works
> From: john...@pharmacy.arizona.edu
> Date: Wed, 5 Oct 2011 10:53:48 -0700
> CC: dbi-users@perl.org
>
>
> On Oct 5, 2011, at 9:09 AM, Scott Stansbury wrote:
>
> >
> > It returns (after a few seconds) with an ORA-12154 error: TNS:could not
> > resolve the connect identifier specified ( SQL-08004).
>
>
> Basic questions: the script is running in an environment where the env
> variables $ORACLE_HOME and $TNS_ADMIN are available? Your tnsnames.ora file
> is present and correct?
>
> (if not, the those vars and put this:
>
> PROD77 =
> (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.15.200)(PORT=1535)))(CONNECT_DATA=(SID=PROD77)))
>
> in a text file, save it as tnsnames.ora in your $ORACLE_HOME directory and
> see if it works now)
>
> --
> Bruce Johnson
> University of Arizona
> College of Pharmacy
> Information Technology Group
>
> Institutions do not have opinions, merely customs
>
>
