RE: DBD::ODBC fails, SQL*Plus works
John Scoles <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.general |
|---|---|
| Message-ID | <[email protected]> |
Why even use DBD::ODBC? Why not use DBD::Oracle? Cheers John > Subject: Re: DBD::ODBC fails, SQL*Plus works > From: [email protected] > Date: Wed, 5 Oct 2011 10:53:48 -0700 > CC: [email protected] > > > 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 > >