Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sources.redhat.com/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com
To: cygwin AT cygwin DOT com
Subject: Re: Exim, .forward and DBD::Oracle
Reply-To: Harald Maier <maierh AT myself DOT com>
References: <Pine DOT GSO DOT 4 DOT 44 DOT 0304132222120 DOT 26381-100000 AT slinky DOT cs DOT nyu DOT edu>
From: Harald DOT Maier DOT BW AT t-online DOT de
Date: Mon, 14 Apr 2003 07:28:54 +0200
In-Reply-To: <Pine.GSO.4.44.0304132222120.26381-100000@slinky.cs.nyu.edu> (Igor
 Pechtchanski's message of "Sun, 13 Apr 2003 22:29:14 -0400 (EDT)")
Message-ID: <u65phmyuh.fsf@myself.com>
User-Agent: Gnus/5.090018 (Oort Gnus v0.18) Emacs/21.3 (windows-nt)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Sender: 320041125923-0001 AT t-dialin DOT net


Igor Pechtchanski <pechtcha AT cs DOT nyu DOT edu> writes:

> On Mon, 14 Apr 2003, Greg Matheson wrote:
>
>> On Sun, 13 Apr 2003, Dmitry Melekhov wrote:
>>
>> > Another problem is with perl in cygwin.  On Linux I can set
>> > $ENV{PATH} and $ENV{ORACLE_HOME} inside perl script, but in
>> > cygwin I had to write shell script to call perl script:

>> Does it work in Linux if you DON'T set $ENV{PATH} and
>> $ENV{ORACLE_HOME} inside your program? Are you sure they are not
>> set elsewhere in your environment?

> You know, Greg, I think you may have gotten it.  Is it possible that
> Perl interprets the "use" statements before the rest of the code,
> and the DBI module tries to load the appropriate DLL in its
> initialization?  Any code that sets the environment variables will
> not have been executed at that point.

Something is really different on Linux and CYGWIN. For example here I
am using an ORACLE_HOME that really don't exist:

,----[ Cygwin ]
| $ ORACLE_HOME=abc TWO_TASK=first ./dbi-test.pl
| Could not connect to first,
| (UNKNOWN OCI STATUS 1804) OCIInitialize. Check ORACLE_HOME and NLS
|   settings etc. at ./dbi-test.pl line 14.
`----

,----[ GNU/Linux ]
| $ ORACLE_HOME=abc TWO_TASK=first ./dbi-test.pl
| SMITH
| ALLEN
| WARD
| ...
`----

On Cygwin it fails and under Linux it works !!!  It looks that the
Linux DBD::Oracle module use an additional fallback method. If
ORACLE_HOME is not valid then it tries again with the ORACLE_HOME
variable at compile time. Under CYGWIN this might not work because of
the DOS Syntax of the ORACLE_HOME (h:/usr/oracle/9.2.0). I am using on
both systems perl-5.8.0 and DBD-Oracle-1.12.

Harald


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/