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
