Perl/Cygwin/Oracle integration problem

MSiipola has asked for the wisdom of the Perl Monks concerning the following question:

I try to connect to Oracle through cygwin, but it fails.
The Oracle version 11.2 is installed on a Windows 2003 server.
Cygwin and Perl is installed on the same server.

cygwin>uname -a
CYGWIN_NT-5.2 N0871 1.7.9(0.237/5/3) 2011-03-29 10:10 i686 Cygwin

cygwin>perl -v
This is perl, v5.10.1 (*) built for i686-cygwin-thread-multi-64int
[download]

The Perl @INC variable contains the current directory ('.')
There is a DBI.pm module installed.
I cd to the directory with the DBI.pm and do:

cygwin>perl -e 'use DBI;'
Can't load './auto/DBI/DBI.dll' for module DBI: <br>
No such file or directory at
at DBI.pm line 263
BEGIN failed--compilation aborted at DBI.pm line 263.
Compilation failed in require at -e line 1.
BEGIN failed--compilation aborted at -e line 1.
[download]

But there is a DBI.dll installed at ./auto/DBI.
Does this mean there is an installation problem or what?
The DBI.pm is preinstalled and I can't change it (e.g. reinstall).

Comment on Perl/Cygwin/Oracle integration problem Select or Download Code

Replies are listed 'Best First'.
Re: Perl/Cygwin/Oracle integration problem by hazylife (Monk) on Mar 28, 2014 at 15:02 UTC
I cd to the directory with the DBI.pm Well, that should not normally be necessary. No such file or directory It may not be referring to DBI.dll itself. What does `ldd auto/DBI/DBI.dll` say?	[reply] [d/l]
Re: Perl/Cygwin/Oracle integration problem by andal (Hermit) on Mar 28, 2014 at 14:31 UTC
Well, '.' in the path indicates that search is relative to "current" directory. What is that "current directory"? Are you sure that perl is in the same "current directory" as you, when it tries to load dll? Is the directory readable for perl process? Try to put full path in @INC.	[reply]
Re: Perl/Cygwin/Oracle integration problem by lithron (Chaplain) on Mar 31, 2014 at 00:27 UTC
I highly suggest upgrading your version of Cygwin to something more recent. That version is from 3 years ago and many things have changed (read: bugs have been fixed). Perl 5.10 isn't distributed by Cygwin any longer, and I suspect DBI is failing to load because gcc and make packages aren't installed and DBI was not compiled properly. Also worth mentioning there is a Cygwin version supporting 64-bit Windows. It works well and is worth trying if your servers support it.	[reply]