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
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 insta
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
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
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
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:
sqlplus