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

Ever since upgrading to perl 5.10 with ActiveState Perl, more and more modules are missing from the repository and surprisingly, DBD::Oracle is one of them!

I really need help installing this, as I don't have any experience in manually doing it. Before that perl package manager would do wonders with just few clicks...:(

I've went to http://search.cpan.org/~pythian/DBD-Oracle-1.20/Oracle.pm and downloaded the source,
(i'm using winxp)

2.) i tried installing it from cpan in dos prompt,

- "install DBD::Oracle"
- then a bunch of files were unzipped, but it ended with these messages : CPAN.pm: Going to build P/PY/PYTHIAN/DBD-Oracle-1.20.tar.gz *** 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. Warning: No success on commandC:\Perl\bin\perl.exe Makefile.PL Warning (usually harmless): 'YAML' not installed, will not store persistent sta e PYTHIAN/DBD-Oracle-1.20.tar.gz C:\Perl\bin\perl.exe Makefile.PL -- NOT OK Running make test Make had some problems, won't test Running make install Make had some problems, won't install Could not read 'C:\Perl\cpan\build\DBD-Oracle-1.20-3aQcLO\META.yml'. Falling ba k to other methods to determine prerequisites Failed during this command: PYTHIAN/DBD-Oracle-1.20.tar.gz : writemakefile NO 'C:\Perl\bin\p rl.exe Makefile.PL' returned status 65280

2.) then i also tried doing make Makefile.pl but it says : MAKE Version 5.2 Copyright (c) 1987, 2000 Borland Fatal: Unable to open makefile
  • Comment on really need help with DBD::Oracle installation

Replies are listed 'Best First'.
Re: really need help with DBD::Oracle installation
by Corion (Patriarch) on Mar 10, 2008 at 08:54 UTC

    What part of the error message is giving you 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.

    You will need to have MS Visual C installed.

    Your version of the make executable is the wrong one. MAKE Version 5.2 Copyright (c) 1987, 2000 Borland indicates that you're using some kind of make tool supplied by Borland. You will need the Microsoft tools.

    You can try to replace your Perl with Strawberry Perl, which includes a matching C compiler and hijacks the environment so that it works right out of the box. It should even be mostly compatible with ActiveState Perl 5.10.

[reply]
[d/l]
[select]
      hi, before trying strawberryperl, isn't visual c++ a commercial product? I tried downloading something from here : http://www.microsoft.com/downloads/thankyou.aspx?familyId=32bc1bee-a3f9-4c13-9c99-220b62a191ee&displayLang=en#

      but that didn't work either, Is there a link to download a free compiler that can compile source files from cpan?
[reply]

        Yes, Microsoft Visual C++ is a commercial product and you usually have pay money to get a license to use it. There are free editions, but ActiveState uses MSVC6 to build ActiveState Perl and you will need version 6 as well if you want to build extensions to it. Version 6 is only available against payment.

        If I may suggest a better approach to your questions, "didn't work either" is not an error description that helps me provide solutions to your questions.

        Is there a link to download a free compiler that can compile source files from cpan?

        As I said already, Strawberry Perl aims to provide an all-in-one package for that. In theory, you can even compile extensions for ActiveState Perl with the toolchain provided by Strawberry Perl.

[reply]
Re: really need help with DBD::Oracle installation
by moritz (Cardinal) on Mar 10, 2008 at 08:51 UTC
[reply]
[d/l]
      i also tried these : ppm install DBD-Oracle
      ppm install DBD::Oracle

      they both returns this :

      ppm install failed: Can't find any package that provides DBD::Oracle
[reply]
Re: really need help with DBD::Oracle installation
by adrive (Scribe) on Mar 11, 2008 at 05:21 UTC
    anyone?
[reply]
[reply]

Back to Seekers of Perl Wisdom