X-Recipient: archive-cygwin AT delorie DOT com X-SWARE-Spam-Status: No, hits=-2.6 required=5.0 tests=AWL,BAYES_00,SPF_PASS X-Spam-Check-By: sourceware.org Message-Id: <7E9056B8-BF50-475C-B046-224AC6CA2DB9@jenika.com> From: Matthew McGillis To: cygwin AT cygwin DOT com In-Reply-To: <3F513B52-C581-4FB4-B2CF-0022384FE511@jenika.com> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v936) Subject: Re: Win32::ODBC fails to load in perl. Date: Fri, 27 Nov 2009 13:03:09 -0800 References: <3F513B52-C581-4FB4-B2CF-0022384FE511 AT jenika DOT com> Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm Precedence: bulk List-Id: List-Unsubscribe: List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner AT cygwin DOT com Mail-Followup-To: cygwin AT cygwin DOT com Delivered-To: mailing list cygwin AT cygwin DOT com 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 #else # include # include # include #endif change to this: // ODBC Stuff # include # include # include Build and install and I get the functionality I'm after. Regards, Matthew On Mar 27, 2009, at 5:37 PM, matthew AT jenika DOT 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