Hi Karthik,
Instead of trying installation through cpan command, try
downloading the source and then build manually from it following
instructions from the link
http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21297335
Seems like when cpan command is issued your env settings is not be
being recognised.
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>
17/12/2009 20:14
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 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"
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
