Installing Bundle::DBI

manishrathi has asked for the wisdom of the Perl Monks concerning the following question:

From link http://search.cpan.org/~timb/DBI-1.609/lib/Bundle/DBI.pm I have downloaded DBI-1.609.tar.gz in the path "C:\Users\manish\Desktop\DBI Module"
I extracted files in the same place.
Now on the command prompt, I went to path C:\Users\manish\Desktop\DBI Module\DBI-1.609
On the command prompt, I am used command "perl makefile.pl" as per the instruction in documentation. I am getting following message

It looks like you don't have a C compiler on your PATH, so you will no
+t be
able to compile C or XS extension modules.  You can install GCC from t
+he
MinGW package using the Perl Package Manager by running:

    ppm install MinGW


*** You are using a perl configured with threading enabled.
*** You should be aware that using multiple threads is
*** not recommended for production environments.

Argument "6.55_02" isn't numeric in numeric ge (>=) at makefile.pl lin
+e 110
*** Warning: whitespace characters in the current directory path (C:/U
+sers/
sh/Desktop/DBI Module/DBI-1.609) may cause problems

*** You're using Microsoft Visual C++ compiler or similar but
    the LIB and INCLUDE environment variables are not both set.

    You need to run the VCVARS32.BAT batch file that was supplied
    with the compiler before you can use it.

    A copy of vcvars32.bat can typically be found in the following
    directories under your Visual Studio install directory:
        Visual C++ 6.0:     vc98\bin
        Visual Studio .NET: vc7\bin

    Find it, run it, then retry this.

    If you think this error is not correct then just set the LIB and
    INCLUDE environment variables to some value to disable the check.
[download]

How do I set INCLUDE and LIB variables ? How can I make this work ? When I am trying to execute perl file (makefile.pl), why am I getting message for C++ ?
Please explain how to set up this environment

Comment on Installing Bundle::DBI Download Code

Replies are listed 'Best First'.
Re: Installing Bundle::DBI by NetWallah (Canon) on Feb 10, 2010 at 01:03 UTC
You are attempting to install a bundle of modules. Modules sometimes contain C code, which is used to implement parts that run faster than the perl equivalent would. There are easier ways to install modules, and on Windows, precompiled, packaged modules are available. First, determine what flavour of perl you use. Run the command: `perl -v` [download] If the output contains the words "Activestate", such as: `Binary build 1003 [285500] provided by ActiveState http://www.ActiveSt +ate.com` [download] Then you can use "PPM" to install modules. In your case, enter: `ppm install DBI` [download] and that should do all the work for you. If it is not activestate, you will probably need to use the "cpan" command. Theory is when you know something, but it doesn't work. Practice is when something works, but you don't know why it works. Programmers combine Theory and Practice: Nothing works and they don't know why. -Anonymous	[reply] [d/l] [select]
Re^2: Installing Bundle::DBI by manishrathi (Beadle) on Feb 10, 2010 at 03:37 UTC
Whats the difference between ActiveState command and CPAN command ? I was under the impression that whatever Perl I install, commands will be the same. I thought, CPAN is central repository for modules and if I need a module, I can download it from there. I did not know that CPAN has commands too. Where ca I find CPAN commands ? How many different flavors of Perl are there for windows ? Whats the reason that so many flavors of Perl are created for windows ? Can anyone create a separate flavor of Perl ? Are the commands very much different for different flavors of Perl ? Are these commands designed separately ? Is it rrequired to program all the commands separatelt or one can keep whatever commands he wants to keep as same and change the commands wherever he wants ? If I have ActiveState perl and I want to change behavior of a command , can I do that ? How to access command files ? How to find commands for these different flavors ? whats the reason that "perl makefile.pl" gives compiler message for c++ ? Is "makefile" C file or Perl file ? How can I use INCLUDE as environment variable ? I dont see it in my liost of environment variables. Do I need to create INCLUDE and LIB separately on my computer ? What values do I need to put in INCLUDE and LIB ?	[reply]
Re^3: Installing Bundle::DBI by NetWallah (Canon) on Feb 10, 2010 at 06:34 UTC
Those are all excellent questions, and I would encourage you to research the subjects in the fine manual that came with your installation, and search the internet. Reasonable questions for this forum would be a lot more specific - after you have made an attempt (like installing DBI), done basic forensics, and have a specific issue. Theory is when you know something, but it doesn't work. Practice is when something works, but you don't know why it works. Programmers combine Theory and Practice: Nothing works and they don't know why. -Anonymous	[reply]