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

2011-10-13 Thread Reinier Post
A side note: DBD::ODBC installs on Cygwin now (it didn't when I tried it a while ago), which has greatly expanded the usefulness of some of my Perl scripts. Thank you, thank you, thank you! -- Reinier Post TU Eindhoven

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

2011-10-07 Thread Martin J. Evans
On 05/10/11 17:09, Scott Stansbury wrote: Folks, I could use a tip or lead with the following issue: I have a Windows Server 2008 R2 box with Oracle Instant Client 11.2, with the SQL*Plus and ODBC modules installed. No other Oracle software is installed. I am connecting to an Oracle 10g

DBD::ODBC fails, SQL*Plus works

2011-10-05 Thread Scott Stansbury
Folks, I could use a tip or lead with the following issue: I have a Windows Server 2008 R2 box with Oracle Instant Client 11.2, with the SQL*Plus and ODBC modules installed. No other Oracle software is installed. I am connecting to an Oracle 10g instance. The following SQL*Plus works:

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

2011-10-05 Thread Bruce Johnson
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

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

2011-10-05 Thread Scott Stansbury
On Oct 5, 2011, at 1:53 PM, Bruce Johnson wrote: 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? I did have the env variables configured, and the tnsnames.ora is now

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

2011-10-05 Thread John Scoles
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