in reply to SQL Server parser

A module that is required by your script is not installed on your system.

Try installing it using ppm like this: ppm install SQLDBA-ParseSQL If it doesn't work ... you'll have to download it & build/install it yourself.

Replies are listed 'Best First'.
Re^2: SQL Server parser
by adhocusage (Initiate) on Nov 28, 2010 at 04:33 UTC

    ppm install SQLDBA-ParseSQL did not work. My bad luck. I will try installing Strawberry perl and see if it will have it. Thanks for the command.

      Strawberryperl won't have it either since it is not distributed on CPAN
Re^2: SQL Server parser
by adhocusage (Initiate) on Nov 30, 2010 at 00:44 UTC
    The book says => To verify the installation is correct, do the following :
    
    cmd> perl -e "use File::Copy;"
    
    cmd> perl -e "use Data::Dumper;"
    
    cmd> perl -e "use Win32::ODBC;"
    
    cmd> perl -e "use Getopt::Std;"
    
    
    
    All these commands return blank line which means the 
    installation is correct. They look for Copy.pm in File 
    subdirectory , Dumper.pm in Data subdirectory etc and the 
    directory and the perl module (pm) files are indeed 
    present. 
    
    However looking for SQLDBA::ParseSQL gives the following error
    
    cmd> perl -e "use SQLDBA::ParseSQL;"
    Can't locate SQLDBA/ParsSQL.pm in @INC 
    (@INC containts: C:/Perl/site/lib C:/Perl64/lib .) at -e line 1.
    BEGIN failed--compilation aborted at -e line 1.
    
    
    
    But i am not seeing SQLDBA subdirectory under either 
    C:\PERL64\lib or C:\PERL64\site\lib; So i created SQLDBA
     subdirectory under both the above directories and tried 
    
    cmd> ppm install SQLDBA-ParseSQL
    
    It ends up giving me the following message:
    
    Downloading ActiveState Package Repository packlist...done
    Updating ActiveState Package Repository database...done
    Syncing site PPM database with .packlists...done
    ppm instail failed: Can't find any package that provides 
    SQLDBA-ParseSQL.
    
    Also , i would like to know where to find and edit the 
    @INC entry. I am working in Windoz and the path should 
    have backslash (\) and not forward slash (/). 
    
    Any suggestions would be welcome. 
    
    
    
      Ok. The author mentions the following are the functions exported by the SQLDBA::Utility
      
      dbaReadINI()
      dbaReadConfig()
      dbaInSet()
      dbaSetCommon()
      dbaSetDiff()
      dbaSetSame()
      dbaRemoveDuplicates()
      dbaTime2str()
      dbaStr2time()
      dbaTimeDiff()
      dbaStringDiff()
      dbaSaveRef()
      dbaReadSaveRef()
      dbaRunQueryADO()
      dbaRunOsql()
      dbaGetTree()
      
      I am seeing the code for the functions. How do i arrive at 
      the .pm file? Do i just concatenate them together or is 
      there any import module? If so how do i do that?
      
      
      Thanks
      
        Ok. I found the solution. The .pm files were present in a 
        separate folder as part of the download. It took me a while 
        to figure this one out. Don't understand why it was kept 
        separately.
        
        Thanks for those who came to my help.