PERL connectivity

  • <pre>

    I am following the book "Real World SQL Server

    Administration with Perl" by Linchi Shea. He has used

    5.6.1 from ActiveState.com; Current / latest version

    available is

    ActivePerl-5.12.2.1202-MSWin32-x64-293621.msi for 64 bit

    and i installed it. perl -v showed the verion correctly.

    Many of the simple scripts run but when i try to run one of

    the scripts it is giving error regarding ParserSQL.pm; I

    invoked ppm and installed all the packages and a search

    after installing does not show any P*SQL.pm;

    The error i am getting is:

    Can't locate SQLDBA/PerseSQL.pm in @INC (@INC contains

    C:/Perl64/site/lib C:/Perl64/site/lib C:/Perl64/lib .)

    at .\reviewSP.pl line 5.

    BEGIN failed--compilation aborted at .\reviewSP.pl line 5.

    The first few lines of reviewSP.pl are as follows:

    </pre>

    <code>

    # See the embedded POD or the HTML documentation

    use strict;

    use Data::Dumper;

    use SQLDBA::ParseSQL qw( dbaNormalizeSQL dbaSplitBatch );

    Main: {

    my $dir = shift or die "***Err: $0 expects a directory name.";

    (-d $dir) or die "***Err: directory $dir does not exist.";

    # read the file names in the directory

    opendir(DIR, $dir) or die "could not open $dir.";

    my @fileNames = map { "$dir\\$_" } grep {!/^\.\.?/} readdir(DIR);

    closedir(DIR);

    my $counterRef;

    </code>

    I did a search on the harddrive / C:\PERL64 but could not come up with any such pm.

    I am newbie to PERL and any help would be appreciated.

    Thanks in Advance.

  • Try searching for the SQLDBA::ParseSQL module in the Perl Package Manager

    Regards,

    Barkha.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply