Re: DBD::ODBC fails, SQL*Plus works

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