Problem on installing DBD-Oracle

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

Hello,

I need to connect to a data base (Oracle). So I need to install DBI then DBD modules.

At first I have installed "ActivePerl-5.8.8.817-MSWin32-x86-257965.msi" because actually I'm a wondows user. Then I have tried to install "DBI-1.30". First ->'perl makeFile.pl' then ->nmake but I got this message:

<<<<<<D:\PerlModules\DBI-1.30>nmake
Microsoft (R) Program Maintenance Utility   Version 1.50
Copyright (c) Microsoft Corp 1988-94. All rights reserved.
        cl -c    -nologo -GF -W3 -MD -Zi -DNDEBUG -O1 -DWIN32 -D_CONSO
+LE -DN
RICT -DHAVE_DES_FCRYPT -DNO_HASH_SEED -DUSE_SITECUSTOMIZE -DPERL_IMPLI
+CIT_CO
T -DPERL_IMPLICIT_SYS -DUSE_PERLIO -DPERL_MSVCRT_READFIX -MD -Zi -DNDE
+BUG -O
 -DVERSION=\"1.30\"  -DXS_VERSION=\"1.30\"  "-IC:\Perl\lib\CORE"   Per
+l.c
'cl' is not recognized as an internal or external command,
operable program or batch file.
NMAKE : fatal error U1077: 'C:\WINDOWS\system32\cmd.exe' : return code
+ '0x1'
Stop.>>>>>
[download]

Edit: g0n - code tags and formatting

Comment on Problem on installing DBD-Oracle Download Code

Replies are listed 'Best First'.
Re: Problem on installing DBD-Oracle by rblasch (Monk) on Jul 01, 2006 at 12:05 UTC
You probably should use PPM to install modules unless you are comfortable with Makefiles and C. DBI and DBD::Oracle are available on ActiveState's PPM server. `ppm` should be available in your ActivePerl's intallation directory, usually C:\Perl\bin\ppm.bat C:\>ppm PPM - Programmer's Package Manager version 3.4. Copyright (c) 2001 ActiveState Software Inc. All Rights Reserved. Entering interactive shell. Using Term::ReadLine::Perl as readline lib +rary. Profile tracking is not enabled. If you save and restore profiles manu +ally, your profile may be out of sync with your computer. See 'help profile' + for more information. Type 'help' to get started. ppm> describe DBI ==================== Name: DBI Version: 1.50 Author: Tim Bunce (dbi-users@perl.org) Title: DBI Abstract: Database independent interface for Perl Location: ActiveState Package Repository Available Platforms: 1. MSWin32-x86-multi-thread-5.8 ==================== ppm> describe DBD-Oracle ==================== Name: DBD-Oracle Version: 1.17 Author: Tim Bunce (dbi-users@perl.org) Title: DBD-Oracle Abstract: Oracle database driver for the DBI module Location: ActiveState Package Repository Available Platforms: 1. MSWin32-x86-multi-thread-5.8 ==================== [download] You can install packages with `install`. ActiveState provides a page describing the build status of the packages. Another repository I like is theoryx5. PPM can handle multiple repositories, you can add them with the `repository add` command. See the ppm documentation for details. PPM::Repositories provides a list of PPM repositories. If you can't find a PPM package for a module you might try asking on the ppm mailing list. See ActiveState's Mailing Lists.	[reply] [d/l] [select]
Re: Problem on installing DBD-Oracle by vkon (Curate) on Jul 01, 2006 at 10:14 UTC
you're trying to build module from source but you do not have compiler installed (your config thinks you should use MSVC++) You probably need to obtain binaries from repository with PPM such as http://aspn.activestate.com/ASPN/Modules?module_name=D&order=name&query_start=106 (but it seems to be for perl5.6.1 perl, you need to search deeper than me:) addition: DBD-Oracle seems to be mentioned at http://aspn.activestate.com/ASPN/Downloads/ActivePerl/PPM/Repository, so your chances to get binaries are very high!	[reply]
Re: Problem on installing DBD-Oracle by Ieronim (Friar) on Jul 01, 2006 at 11:25 UTC
ppm is always supplied with ActiveState Perl. Add "\bin" directory inside your Perl directory to your path and run ppm. PPM is Perl Package Manager, the program for installing Perl modules from precompiled packages, usually availible online. It has its own good documentation. RTFM! You will use it many times later :)	[reply]