Connect to DB2 Database with Perl DBI in Windows 7

[concerto5]

Hi all Monks. First time post. Have been using Perl for about a year now and want to connect to my companies' database to speed up data retrieval. My company is using DB2. I have strawberry Perl 32-bit and Windows 7 64-bit. I honestly do not know where to start. The reason I say this is because it seems like connecting to DB2 requires a bit more legwork than other databases. As of now, I simply have Perl DBI installed and that's it. Any advice (remember I am a novice) on how to begin in order to connect to a DB2 database? Thanks.

[dasgar]

I haven't used DB2 in any capacity, but I'm thinking that Corion's suggestion makes sense - install needed client before installing DBD::DB2.

Alternatively, I'm wondering if there is an ODBC driver for DB2 access. If there is, then installing that and using DBD::ODBC might work too.

In any case, I suspect that you'll need to install some kind of DB2 driver and/or client before you can gain access via any Perl modules.

[pme]

Hi concerto5,

Welcome to the monastery!

Just install DBD::DB2 from http://www.cpan.org. Strawberry perl must have its own CPAN installer tool.

[concerto5]

Thanks for the reply. When installing in CPAN i get the following error: Failed during this command: IBMTORDB2/DBD-DB2-1.85.tar.gz : writemakefile NO 'C:\Strawberry\perl\bin\perl.exe Makefile.PL' returned status 512

[1nickt]

See this issue report, which suggests that the problem is because the code doesn't compile with the gcc bundled with Strawberry Perl.

I believe that the core issue is gcc compiler support under Windows. T
+here 
is a history here... that shows that in 2010, a patch was contributed 
+for 
DBD::DB2 1.78 for gcc on Windows.    DBD::DB2 1.85, the current versio
+n on 
CPAN, doesn't include this patch (or it no longer works).

[pme]

Can you see this message couple of lines above? "DB2_HOME environment variable must be set to installed location of DB2." This may be the reason. I have never used DB2.

[anonymized user 468275]

If you are missing dependencies, there is also Bundle::DBD::DB2 that includes them as well. If that doesn't install, you could try downloading the tarball (.tar.gz file) by clicking on the breadcrumb in front of the above name, and then on the download link and the file will download. Use 7-zip or similar archive software to extract firstly from the .gz and then extract again from the resulting .tar file, then in a DOS prompt: cd to where you extracted from .tar, then

perl Makefile.PL
dmake
dmake test
dmake install

[rahulruns]

Try using active state Perl. Could solve your problem. I have used it and pretty much things are available. If you are using PPM to install try using cpan command line. Just suggestions