Connecting Tech Pros Worldwide Help | Site Map

Need DBI:Excel and SQL modules

Newbie
 
Join Date: Apr 2009
Posts: 13
#1: May 6 '09
I am using excel as database for my project. We are getting following error while making database connection,

install_driver(Excel) failed: Can't locate loadable object for module Clone in @
INC (@INC contains: D:/Perl/site/lib D:/Perl/lib .) at D:/Perl/lib/SQL/Statement
.pm line 14
Compilation failed in require at D:/Perl/lib/SQL/Statement.pm line 14.
BEGIN failed--compilation aborted at D:/Perl/lib/SQL/Statement.pm line 14.


When I looked in D:/Perl/lib/SQL/Statement.pm file, at step 14 is calling following statement "use Clone qw(clone);" .... although there is no sub routine with name clone in Clone.pm. Can any body to help to solve this problem. Do we have incomplete package, if it is then please suggest the link where we can get the complete module.

Thanks in Advance
-Lav
nithinpes's Avatar
Expert
 
Join Date: Dec 2007
Posts: 400
#2: May 7 '09

re: Need DBI:Excel and SQL modules


The Clone.pm module has a clone() method defined in it. Try reinstalling the module.
The error points out that Clone module is either not installed or Clone.pm in not present in the paths contained in @INC (library paths). If the module is present in a different location, use one of the following approaches to add the path. Both of these need to be at the beginning of script.

Expand|Select|Wrap|Line Numbers
  1. use lib 'new\path';
  2.  
OR

Expand|Select|Wrap|Line Numbers
  1. BEGIN {
  2.  
  3.  push @INC, 'new\path';
  4. }
  5.  
KevinADC's Avatar
Expert
 
Join Date: Jan 2007
Location: Southern California USA
Posts: 4,091
#3: May 7 '09

re: Need DBI:Excel and SQL modules


Clone.pm does not come with perl so you will need to try and install it. See the Perl Package Manager (PPM) instructions in the activeperl documentation for instructions on how to install modules.
Newbie
 
Join Date: Apr 2009
Posts: 13
#4: May 8 '09

re: Need DBI:Excel and SQL modules


ok...let me try this way.....

thanks.....
Reply