Hi Jeff, Same problem:
C:\Documents and Settings\thakore\Desktop\HLM>cpan DBD::DB2 Database was generated on Wed, 16 Dec 2009 16:54:25 GMT Running install for module 'DBD::DB2' Running make for I/IB/IBMTORDB2/DBD-DB2-1.76.tar.gz Checksum for C:\strawberry\cpan\sources\authors\id\I\IB\IBMTORDB2\DBD-DB2-1.76.tar.gz ok CPAN.pm: Going to build I/IB/IBMTORDB2/DBD-DB2-1.76.tar.gz Configuring DBD::DB2... Remember to actually read the README and CAVEATS files! Using DB2 in "C:/Program Files/IBM/SQLLIB" System: perl5.010001 DBI1.609 Win32 strawberryperl 5.10.1.0 #1 30 i386 MSWin32-x86-multi-thread dl_win32.xs Compiler: gcc -s -O2 -s -O2 -DWIN32 -DHAVE_DES_FCRYPT -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPL Includes: -I"C:/Program Files/IBM/SQLLIB/include" -I"C:\strawberry\perl\site\lib/auto/DBI" -I"C:\strawberry\pe Libraries: -L"C:/Program Files/IBM/SQLLIB/lib" db2cli.lib db2api.lib Checking if your kit is complete... Looks good Note (probably harmless): No library found for db2cli.lib Note (probably harmless): No library found for db2api.lib Regards -----Original Message----- From: jse...@gmail.com [mailto:jse...@gmail.com] On Behalf Of Jeffrey Seger Sent: Thursday, December 17, 2009 11:10 AM To: Thakore, Kartik Cc: dbi-users@perl.org Subject: Re: DBD::DB2 on Windows with Strawberry Perl On Thu, Dec 17, 2009 at 9:44 AM, Thakore, Kartik <kartik.thak...@cibc.com> wrote: > HI Praveen, > > I am getting the same problem. The weird thing Is I have both those files in > C:\Program Files\IBM\SQLLIB\lib > > C:\ >set LIB=C:\Program Files\IBM\SQLLIB\lib > > C:\ >set DB2_HOME=C:\Program Files\IBM\SQLLIB\lib > > C:\ >cpan DBD::DB2 > Database was generated on Wed, 16 Dec 2009 16:54:25 GMT > Running install for module 'DBD::DB2' > Running make for I/IB/IBMTORDB2/DBD-DB2-1.76.tar.gz > Checksum for > C:\strawberry\cpan\sources\authors\id\I\IB\IBMTORDB2\DBD-DB2-1.76.tar.gz ok > > CPAN.pm: Going to build I/IB/IBMTORDB2/DBD-DB2-1.76.tar.gz > > > Configuring DBD::DB2... > Remember to actually read the README and CAVEATS files! > > Using DB2 in "C:/Program Files/IBM/SQLLIB/lib" > System: perl5.010001 DBI1.609 Win32 strawberryperl 5.10.1.0 #1 30 i386 > MSWin32-x86-multi-thread dl_win32.xs > Compiler: gcc -s -O2 -s -O2 -DWIN32 -DHAVE_DES_FCRYPT -DUSE_SITECUSTOMIZE > -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -fno-strict-aliasing > -DPERL_MSVCRT_READFIX > Includes: -I"C:/Program Files/IBM/SQLLIB/lib/include" > -I"C:\strawberry\perl\site\lib/auto/DBI" -I"C:\strawberry\perl\lib/auto/DBI" > -I"C:\strawberry\perl\vendor\lib/auto/DBI" > -I"C:\strawberry\perl\site\lib/auto/DBI" > Libraries: -L"C:/Program Files/IBM/SQLLIB/lib/lib" db2cli.lib db2api.lib > -L"C:/Program Files/IBM/SQLLIB/lib" see the lib/lib? Drop the /lib from the end of your DB2_HOME. > > Checking if your kit is complete... > Looks good > Note (probably harmless): No library found for db2cli.lib > Note (probably harmless): No library found for db2api.lib > > > Regards > ________________________________ > From: Praveen Devarao [mailto:praveen...@in.ibm.com] > Sent: Wednesday, December 16, 2009 11:35 PM > To: Thakore, Kartik > Cc: dbi-users@perl.org > Subject: RE: DBD::DB2 on Windows with Strawberry Perl > > > Hi Kartik, > > During compilation there are 2 warnings, as below > > Note (probably harmless): No library found for db2cli.lib > Note (probably harmless): No library found for db2api.lib > > Seems like you don't have the DB2 lib path ( C:\Program > Files\IBM\SQLLIB\lib ) in you environment setting. Set the DB2_HOME env > variable as below and you should be able to successfully compile and install > the DBD-DB2 driver. > > set DB2_HOME=C:\Program Files\IBM\SQLLIB\lib or set LIB=C:\Program > Files\IBM\SQLLIB\lib;%LIB% > > If setting these variables don't work, then check the location > C:\Program Files\IBM\SQLLIB\lib to ensure that the necessary libraries are > present, if not then you might want to re-check you DB2 installation. (FYI: > If this the case seems like you have opted for a custom installation of DB2 > and have not selected application development tools. you might want to add > this pack too) > > > Regarding the ppm install, as mentioned earlier, the ppd packages in > that repository is for ActiveState Perl, hence might be there is some > mismatches. > > Let me know how it goes. > > Thanking You > ------------------------------------------------------------------------- > Praveen D > Manyata Embassy Business Park > D2,1st Floor,Outer Ring Road Nagavara > Rachenahalli,Bangalore:560 045 > Email : praveen...@in.ibm.com > ------------------------------------------------------------------------- > > "Thakore, Kartik" <kartik.thak...@cibc.com> > > 16/12/2009 23:55 > > To > > Praveen Devarao/India/i...@ibmin > > cc > > "dbi-users@perl.org" <dbi-users@perl.org> > > Subject > > RE: DBD::DB2 on Windows with Strawberry Perl > > > > > > > > > > > Hi, > This is db2level: > > DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL09071" with > level identifier "08020107". > Informational tokens are "DB2 v9.7.100.177", "s091114", "IP23028", and Fix > Pack > "1". > Product is installed at "C:\PROGRA~1\IBM\SQLLIB" with DB2 Copy Name > "DB2LOCAL". > > Also I tried cpan DBD::DB2 to try an compile but I get the first errors. Then > I used Strawberry ppm to install DBD::DB2 from the Winnipeg location. > > Using this: ppm install http://cpan.uwinnipeg.ca/PPMPackages/10xx/DBD-DB2.ppd > > Thank you > Kartik Thakore > > -----Original Message----- > From: Praveen [mailto:praveen...@in.ibm.com] > Sent: Wednesday, December 16, 2009 7:59 AM > To: dbi-users@perl.org > Subject: Re: DBD::DB2 on Windows with Strawberry Perl > > Hi Kartik, > > Seems like your installation is not taken place properly. Could you > let me know if the DBD-DB2 driver was taken from cpan or from the > uwinnipeg repository ( ppm install > http://theoryx5.uwinnipeg.ca/ppms/DBD-DB2.ppd > ). The winnipeg respository contains DBD-DB2 for ActivePerl (from > activestate), hence might be the problem. > > If you are trying a manual installation then you might want to go > through this page for steps of manual installation on windows (for > which you will need MingW compiler and dmake utility or VC). > http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21297335 [Note: > currently the page shows 1.75 as latest, but it is 1.76 (the page > update process is in progress)]. > > If your problem is still not solved could you provide with the details > of DB2 version being used (db2level). > > Thanks > > Praveen > > -- They who would give up an essential liberty for temporary security, deserve neither liberty or security. Benjamin Franklin Our lives begin to end the day we become silent about things that matter. Martin Luther King The right of the people to be secure in their persons, houses, papers, and effects, against unreasonable searches and seizures, shall not be violated, and no warrants shall issue, but upon probable cause, supported by oath or affirmation, and particularly describing the place to be searched, and the persons or things to be seized. Amendment IV to the Constitution of the United States "I am not going to answer any questions as to my association, my philosophical or religious beliefs or my political beliefs, or how I voted in any election, or any of these private affairs. I think these are very improper questions for any American to be asked, especially under such compulsion as this." Pete Seeger before the House Un-American Activities Comittee
