This is the mail archive of the cygwin mailing list for the Cygwin project.


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

Re: Win32::ODBC fails to load in perl.


This issue still exists.

Personally I really don't want the cygwin version to use the cygwin iODBC libraries. I like the cygwin Win32::ODBC to use the windows ODBC dll. I would rather see a Win32::iODBC module or something like that if i want to use the cygwin iODBC libraries over the windows ODBC libraries.

Just my 2c.

So for my own purposes I download the Win32::ODBC
modify ODBC.xs to remove dependancy on iODBC

find this:

// ODBC Stuff
    //  ODBC Stuff
#ifdef __CYGWIN__
#   include <iodbcinst.h>
#else
#   include <sql.h>
#   include <sqlext.h>
#   include <odbcinst.h>
#endif
change to this:
    //  ODBC Stuff
#   include <sql.h>
#   include <sqlext.h>
#   include <odbcinst.h>
Build and install and I get the functionality I'm after.

Regards,
Matthew

On Mar 27, 2009, at 5:37 PM, matthew@jenika.com wrote:

The following simple perl script.

#!/usr/bin/perl

use Win32::ODBC;

When run results in:

Can't load '/usr/lib/perl5/vendor_perl/5.10/i686-cygwin/auto/Win32/ ODBC/ODBC.dll' for module Win32::ODBC: No such file or directory at / usr/lib/perl5/5.10/i686-cygwin/DynaLoader.pm line 201.
at ./a line 3
Compilation failed in require at ./a line 3.
BEGIN failed--compilation aborted at ./a line 3.


This is the actual file:
ls -al /usr/lib/perl5/vendor_perl/5.10/i686-cygwin/auto/Win32/ODBC/ ODBC.dll
-rwxr-xr-x+ 1 Administrator Users 189952 Feb 16 2008 /usr/lib/perl5/ vendor_perl/5.10/i686-cygwin/auto/Win32/ODBC/ODBC.dll



Cygwin Configuration Diagnostics Current System Time: Fri Mar 27 17:36:04 2009

Windows 2003 Server Ver 5.2 Build 3790 Service Pack 2

Running in Terminal Service session

Path:
	c:\Program Files\SysInternals
	c:\WINDOWS\Microsoft.Net\Framework\v3.5
	c:\Program Files\GnuWin32\bin
	C:\cygwin\usr\local\bin
	C:\cygwin\bin
	C:\cygwin\bin
	C:\cygwin\usr\X11R6\bin
	c:\Program Files\Windows Resource Kits\Tools\
	c:\WINDOWS\system32
	c:\WINDOWS
	c:\WINDOWS\System32\Wbem
	c:\Program Files\Microsoft SQL Server\80\Tools\BINN
	c:\WINDOWS\idmu\common


SysDir: C:\WINDOWS\system32 WinDir: C:\WINDOWS

USER = 'mmcgillis'
PWD = '/cygdrive/c/Temp'
MAKE_MODE = 'unix'

HKEY_CURRENT_USER\Software\Cygnus Solutions
HKEY_CURRENT_USER\Software\Cygnus Solutions\Cygwin
HKEY_CURRENT_USER\Software\Cygnus Solutions\Cygwin\mounts v2
HKEY_CURRENT_USER\Software\Cygnus Solutions\Cygwin\Program Options
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2
 (default) = '/cygdrive'
 cygdrive flags = 0x00000022
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/
 (default) = 'C:\cygwin'
 flags = 0x0000000a
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/usr/bin
 (default) = 'C:\cygwin/bin'
 flags = 0x0000000a
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/usr/lib
 (default) = 'C:\cygwin/lib'
 flags = 0x0000000a
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\Program Options

a:  fd             N/A    N/A
c:  hd  NTFS     25587Mb  18% CP CS UN PA FC
d:  cd  CDFS       227Mb 100%    CS              OFFICE11
e:  hd  NTFS     30718Mb  78% CP CS UN PA FC     New Volume
h:  net NTFS    169914Mb  92% CP CS UN PA FC     Data
p:  net NTFS    697839Mb  74% CP CS UN PA        Data
s:  net NTFS    169914Mb  92% CP CS UN PA FC     Data
t:  net NTFS    208852Mb  68% CP CS UN PA FC
u:  net NTFS    169914Mb  92% CP CS UN PA FC     Data
v:  net NTFS    228878Mb  29% CP CS UN PA FC
y:  net NTFS    169914Mb  92% CP CS UN PA FC     Data
z:  net NTFS    169914Mb  92% CP CS UN PA FC     Data

C:\cygwin      /          system  binmode
C:\cygwin/bin  /usr/bin   system  binmode
C:\cygwin/lib  /usr/lib   system  binmode
.              /cygdrive  system  binmode,cygdrive

Found: C:\cygwin\bin\awk.exe
Found: C:\cygwin\bin\bash.exe
Found: C:\cygwin\bin\cat.exe
Found: C:\cygwin\bin\cp.exe
Not Found: cpp (good!)
Not Found: crontab
Found: C:\cygwin\bin\find.exe
Not Found: gcc
Not Found: gdb
Found: C:\cygwin\bin\grep.exe
Found: C:\cygwin\bin\kill.exe
Found: C:\cygwin\bin\ld.exe
Found: C:\cygwin\bin\ls.exe
Not Found: make
Found: C:\cygwin\bin\mv.exe
Not Found: patch
Found: C:\cygwin\bin\perl.exe
Found: C:\cygwin\bin\rm.exe
Found: C:\cygwin\bin\sed.exe
Found: C:\cygwin\bin\ssh.exe
Found: C:\cygwin\bin\sh.exe
Found: C:\cygwin\bin\tar.exe
Found: C:\cygwin\bin\test.exe
Not Found: vi
Found: C:\cygwin\bin\vim.exe

61k 2009/03/02 C:\cygwin\bin\cygbz2-1.dll - os=4.0 img=1.0 sys=4.0
"cygbz2-1.dll" v0.0 ts=2009/3/1 18:52
7k 2003/10/19 C:\cygwin\bin\cygcrypt-0.dll - os=4.0 img=1.0 sys=4.0
"cygcrypt-0.dll" v0.0 ts=2003/10/19 0:57
1075k 2009/03/25 C:\cygwin\bin\cygcrypto-0.9.8.dll - os=4.0 img=1.0 sys=4.0
"cygcrypto-0.9.8.dll" v0.0 ts=2009/3/25 10:21
943k 2007/12/17 C:\cygwin\bin\cygdb-4.5.dll - os=4.0 img=1.0 sys=4.0
"cygdb-4.5.dll" v0.0 ts=2007/12/17 5:12
1296k 2007/12/17 C:\cygwin\bin\cygdb_cxx-4.5.dll - os=4.0 img=1.0 sys=4.0
"cygdb_cxx-4.5.dll" v0.0 ts=2007/12/17 5:12
118k 2008/05/09 C:\cygwin\bin\cygexpat-1.dll - os=4.0 img=1.0 sys=4.0
"cygexpat-1.dll" v0.0 ts=2008/5/8 21:03
161k 2008/06/01 C:\cygwin\bin\cygfontconfig-1.dll - os=4.0 img=1.0 sys=4.0
"cygfontconfig-1.dll" v0.0 ts=2008/6/1 15:16
19k 2008/10/26 C:\cygwin\bin\cygfontenc-1.dll - os=4.0 img=1.0 sys=4.0
"cygfontenc-1.dll" v0.0 ts=2008/10/26 14:25
40k 2009/03/01 C:\cygwin\bin\cygform-8.dll - os=4.0 img=1.0 sys=4.0
"cygform-8.dll" v0.0 ts=2009/2/28 18:40
41k 2009/03/27 C:\cygwin\bin\cygform-9.dll - os=4.0 img=1.0 sys=4.0
"cygform-9.dll" v0.0 ts=2009/3/26 17:37
860k 2008/03/23 C:\cygwin\bin\cygfpx-1.dll - os=4.0 img=1.0 sys=4.0
"cygfpx-1.dll" v0.0 ts=2008/3/23 13:12
430k 2009/01/28 C:\cygwin\bin\cygfreetype-6.dll - os=4.0 img=1.0 sys=4.0
"cygfreetype-6.dll" v0.0 ts=2009/1/27 21:48
42k 2009/03/12 C:\cygwin\bin\cyggcc_s-1.dll - os=4.0 img=1.0 sys=4.0
"cyggcc_s-1.dll" v0.0 ts=2009/3/6 3:54
19k 2009/02/26 C:\cygwin\bin\cyggdbm-4.dll - os=4.0 img=1.0 sys=4.0
"cyggdbm-4.dll" v0.0 ts=2009/2/25 23:55
8k 2009/02/26 C:\cygwin\bin\cyggdbm_compat-4.dll - os=4.0 img=1.0 sys=4.0
"cyggdbm_compat-4.dll" v0.0 ts=2009/2/25 23:56
24k 2008/11/29 C:\cygwin\bin\cyghistory6.dll - os=4.0 img=1.0 sys=4.0
"cyghistory6.dll" v0.0 ts=2008/11/29 6:30
271k 2007/08/24 C:\cygwin\bin\cygicons-0.dll - os=4.0 img=1.0 sys=4.0
"cygicons-0.dll" v0.0 ts=2007/8/24 0:24
978k 2008/11/10 C:\cygwin\bin\cygiconv-2.dll - os=4.0 img=1.0 sys=4.0
"cygiconv-2.dll" v0.0 ts=2008/11/9 16:35
37k 2003/08/10 C:\cygwin\bin\cygintl-2.dll - os=4.0 img=1.0 sys=4.0
"cygintl-2.dll" v0.0 ts=2003/8/10 14:50
31k 2005/11/20 C:\cygwin\bin\cygintl-3.dll - os=4.0 img=1.0 sys=4.0
"cygintl-3.dll" v0.0 ts=2005/11/19 18:04
31k 2008/12/31 C:\cygwin\bin\cygintl-8.dll - os=4.0 img=1.0 sys=4.0
"cygintl-8.dll" v0.0 ts=2008/12/30 23:42
246k 2008/04/02 C:\cygwin\bin\cygjasper-1.dll - os=4.0 img=1.0 sys=4.0
"cygjasper-1.dll" v0.0 ts=2008/4/2 9:19
41k 2009/03/10 C:\cygwin\bin\cygjbig-2.dll - os=4.0 img=1.0 sys=4.0
"cygjbig-2.dll" v0.0 ts=2009/3/9 18:52
125k 2009/03/08 C:\cygwin\bin\cygjpeg-62.dll - os=4.0 img=1.0 sys=4.0
"cygjpeg-62.dll" v0.0 ts=2009/3/7 19:31
173k 2008/03/23 C:\cygwin\bin\cyglcms-1.dll - os=4.0 img=1.0 sys=4.0
"cyglcms-1.dll" v0.0 ts=2008/3/23 3:35
395k 2008/04/17 C:\cygwin\bin\cygMagick++-1.dll - os=4.0 img=1.0 sys=4.0
"cygMagick++-1.dll" v0.0 ts=2008/4/17 12:21
1915k 2008/04/17 C:\cygwin\bin\cygMagickCore-1.dll - os=4.0 img=1.0 sys=4.0
"cygMagickCore-1.dll" v0.0 ts=2008/4/17 12:05
782k 2008/04/17 C:\cygwin\bin\cygMagickWand-1.dll - os=4.0 img=1.0 sys=4.0
"cygMagickWand-1.dll" v0.0 ts=2008/4/17 12:17
21k 2009/03/01 C:\cygwin\bin\cygmenu-8.dll - os=4.0 img=1.0 sys=4.0
"cygmenu-8.dll" v0.0 ts=2009/2/28 18:38
21k 2009/03/27 C:\cygwin\bin\cygmenu-9.dll - os=4.0 img=1.0 sys=4.0
"cygmenu-9.dll" v0.0 ts=2009/3/26 17:36
24k 2008/10/30 C:\cygwin\bin\cygminires.dll - os=4.0 img=1.2 sys=4.0
"cygminires.dll" v0.0 ts=2008/10/30 16:53
66k 2009/03/01 C:\cygwin\bin\cygncurses++-8.dll - os=4.0 img=1.0 sys=4.0
"cygncurses++-8.dll" v0.0 ts=2009/2/28 18:50
335k 2009/03/27 C:\cygwin\bin\cygncurses++-9.dll - os=4.0 img=1.0 sys=4.0
"cygncurses++-9.dll" v0.0 ts=2009/3/26 17:45
237k 2009/03/01 C:\cygwin\bin\cygncurses-8.dll - os=4.0 img=1.0 sys=4.0
"cygncurses-8.dll" v0.0 ts=2009/2/28 18:36
165k 2009/03/27 C:\cygwin\bin\cygncurses-9.dll - os=4.0 img=1.0 sys=4.0
"cygncurses-9.dll" v0.0 ts=2009/3/26 17:34
11k 2009/03/01 C:\cygwin\bin\cygpanel-8.dll - os=4.0 img=1.0 sys=4.0
"cygpanel-8.dll" v0.0 ts=2009/2/28 18:38
11k 2009/03/27 C:\cygwin\bin\cygpanel-9.dll - os=4.0 img=1.0 sys=4.0
"cygpanel-9.dll" v0.0 ts=2009/3/26 17:36
181k 2008/09/07 C:\cygwin\bin\cygpcre-0.dll - os=4.0 img=1.0 sys=4.0
"cygpcre-0.dll" v0.0 ts=2008/9/6 20:36
302k 2008/09/07 C:\cygwin\bin\cygpcrecpp-0.dll - os=4.0 img=1.0 sys=4.0
"cygpcrecpp-0.dll" v0.0 ts=2008/9/6 20:36
7k 2008/09/07 C:\cygwin\bin\cygpcreposix-0.dll - os=4.0 img=1.0 sys=4.0
"cygpcreposix-0.dll" v0.0 ts=2008/9/6 20:36
1543k 2008/07/03 C:\cygwin\bin\cygperl5_10.dll - os=4.0 img=1.0 sys=4.0
"cygperl5_10.dll" v0.0 ts=2008/6/30 9:06
243k 2009/03/07 C:\cygwin\bin\cygpng12.dll - os=4.0 img=1.0 sys=4.0
"cygpng12.dll" v0.0 ts=2009/3/7 13:04
22k 2002/06/09 C:\cygwin\bin\cygpopt-0.dll - os=4.0 img=1.0 sys=4.0
"cygpopt-0.dll" v0.0 ts=2002/6/8 22:45
155k 2008/11/29 C:\cygwin\bin\cygreadline6.dll - os=4.0 img=1.0 sys=4.0
"cygreadline6.dll" v0.0 ts=2008/11/29 6:30
232k 2009/03/25 C:\cygwin\bin\cygssl-0.9.8.dll - os=4.0 img=1.0 sys=4.0
"cygssl-0.9.8.dll" v0.0 ts=2009/3/25 10:22
66k 2009/03/27 C:\cygwin\bin\cygtic-9.dll - os=4.0 img=1.0 sys=4.0
"cygtic-9.dll" v0.0 ts=2009/3/26 17:31
311k 2009/03/08 C:\cygwin\bin\cygtiff-5.dll - os=4.0 img=1.0 sys=4.0
"cygtiff-5.dll" v0.0 ts=2009/3/8 14:33
281k 2009/03/08 C:\cygwin\bin\cygtiffxx-5.dll - os=4.0 img=1.0 sys=4.0
"cygtiffxx-5.dll" v0.0 ts=2009/3/8 14:33
22k 2008/02/24 C:\cygwin\bin\cygwrap-0.dll - os=4.0 img=1.0 sys=4.0
"cygwrap-0.dll" v0.0 ts=2008/2/22 23:03
885k 2009/01/29 C:\cygwin\bin\cygX11-6.dll - os=4.0 img=1.0 sys=4.0
"cygX11-6.dll" v0.0 ts=2009/1/28 8:11
8k 2008/10/24 C:\cygwin\bin\cygXau-6.dll - os=4.0 img=1.0 sys=4.0
"cygXau-6.dll" v0.0 ts=2008/10/24 10:36
77k 2009/02/09 C:\cygwin\bin\cygxcb-1.dll - os=4.0 img=1.0 sys=4.0
"cygxcb-1.dll" v0.0 ts=2009/2/8 20:06
5k 2009/02/09 C:\cygwin\bin\cygxcb-xlib-0.dll - os=4.0 img=1.0 sys=4.0
"cygxcb-xlib-0.dll" v0.0 ts=2009/2/8 20:06
16k 2008/10/24 C:\cygwin\bin\cygXdmcp-6.dll - os=4.0 img=1.0 sys=4.0
"cygXdmcp-6.dll" v0.0 ts=2008/10/24 12:14
49k 2008/10/26 C:\cygwin\bin\cygXext-6.dll - os=4.0 img=1.0 sys=4.0
"cygXext-6.dll" v0.0 ts=2008/10/25 20:25
1082k 2009/01/28 C:\cygwin\bin\cygxml2-2.dll - os=4.0 img=1.0 sys=4.0
"cygxml2-2.dll" v0.0 ts=2009/1/27 20:37
65k 2009/03/02 C:\cygwin\bin\cygz.dll - os=4.0 img=1.0 sys=4.0
"cygz.dll" v0.0 ts=2009/3/1 17:19
1829k 2008/06/12 C:\cygwin\bin\cygwin1.dll - os=4.0 img=1.0 sys=4.0
"cygwin1.dll" v0.0 ts=2008/6/12 10:35
Cygwin DLL version info:
DLL version: 1.5.25
DLL epoch: 19
DLL bad signal mask: 19005
DLL old termios: 5
DLL malloc env: 28
API major: 0
API minor: 156
Shared data: 4
DLL identifier: cygwin1
Mount registry: 2
Cygnus registry name: Cygnus Solutions
Cygwin registry name: Cygwin
Program options name: Program Options
Cygwin mount registry name: mounts v2
Cygdrive flags: cygdrive flags
Cygdrive prefix: cygdrive prefix
Cygdrive default prefix:
Build date: Thu Jun 12 19:34:46 CEST 2008
CVS tag: cr-0x5f1
Shared id: cygwin1S4



Cygwin Package Information
Last downloaded files to: C:\Documents and Settings \Administrator.DOMAIN\Desktop
Last downloaded files from: ftp://cygwin.osuosl.org/pub/cygwin/


Package                 Version
_update-info-dir        00812-1
alternatives            1.3.30c-2
ash                     20040127-4
base-files              3.7-1
base-passwd             2.2-1
bash                    3.2.48-21
binutils                20080624-2
bzip2                   1.0.5-3
coreutils               6.10-2
crypt                   1.1-1
csih                    0.1.8-1
cvs                     1.11.22-1
cvsutils                0.2.5-1
cygrunsrv               1.34-1
cygutils                1.3.2-1
cygwin                  1.5.25-15
cygwin-doc              1.4-4
diffutils               2.8.7-1
e2fsprogs               1.35-3
editrights              1.01-2
expat                   2.0.1-1
findutils               4.4.0-3
font-bitstream-vera-ttf 1.10-1
fontconfig              2.6.0-1
gawk                    3.1.6-1
grep                    2.5.3-1
groff                   1.19.2-2
gzip                    1.3.12-2
less                    382-1
libbz2_1                1.0.5-3
libdb4.5                4.5.20.2-2
libexpat1               2.0.1-1
libexpat1-devel         2.0.1-1
libfontconfig1          2.6.0-1
libfontenc1             1.0.4-2
libfpx1                 1.2.0.13-1
libfreetype26           2.3.8-1
libfreetype6            2.3.8-1
libgcc1                 4.3.2-2
libgdbm4                1.8.3-9
libiconv2               1.12-1
libImageMagick1         6.4.0.6-1
libintl2                0.12.1-3
libintl3                0.14.5-1
libintl8                0.17-3
libjasper1              1.900.1-1
libjbig2                2.0-1
libjpeg62               6b-13
liblcms1                1.17-1
libncurses8             5.5-4
libncurses9             5.7-5
libpcre0                7.8-1
libpng12                1.2.35-1
libpopt0                1.6.4-4
libreadline6            5.2.13-11
libtiff5                3.8.2-4
libwrap0                7.6-4
libX11_6                1.1.5-2
libXau6                 1.0.4-1
libxcb-xlib0            1.1-3
libxcb1                 1.1-3
libXdmcp6               1.0.2-3
libXext6                1.0.4-1
libxml2                 2.7.3-1
login                   1.9-8
man                     1.6e-1
minires                 1.02-1
mkfontdir               1.0.4-1
mkfontscale             1.0.5-1
ncurses                 5.7-5
openssh                 5.1p1-10
openssl                 0.9.8k-1
perl                    5.10.0-5
perl-libwin32           0.28-2
perl_manpages           5.10.0-5
pkg-config              0.23a-2
rebase                  2.4.4-1
run                     1.1.10-1
rxvt                    20050409-9
sed                     4.1.5-2
sharutils               4.7-1
tar                     1.21-1
termcap                 20050421-1
terminfo                5.7_20090228-1
terminfo0               5.5_20061104-2
texinfo                 4.13-2
tzcode                  2008h-1
unzip                   5.52-3
util-linux              2.14.1-1
vim                     7.2-3
w32api                  3.13-1
which                   2.20-1
zip                     3.0-2
zlib                    1.2.3-3
zlib-devel              1.2.3-3
zlib0                   1.2.3-3
Use -h to see help about each section



--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]