On Mon, Jul 28, 2008 at 8:06 AM, Srinivas KATTI <[EMAIL PROTECTED]>wrote:
> I am working on perl assignment which is first perl code in our
> environment, i have come across following problem, pls if you could
> provide your expert consultansy it will be great help to me
>
> I am trying to use DBI in my program (simple program), below is the piece
> of code
>
>
> ************************************************************************************************************************************************
> #!/usr/bin/perl -w
> #use lib '/tools/dev/perl_modules/DBI/1.48/DBI-1.48';
>
> BEGIN {
> push @INC,"/tools/dev/perl_modules/DBI/1.48/DBI-1.48";
> }
Try /tools/dev/perl_modules -- Perl will add the sub-directories.
See the other directories on @INC for examples.
Or, maybe, you need to add blib to the end of the name you're using.
If you haven't installed DBI yet, do so -- don't try to use it (or build any
DBD modules) until it is installed. Doing that prevents this sort of
headache.
> use DBI;
> use strict;
> my $dbh = DBI->connect( 'dbi:Sybase:SNYCTLDBD01',
> 'glrecadm',
> 'glrecadm',
> {
> RaiseError => 1,
> AutoCommit => 0
> }
> ) || die "Database connection not made:
> $DBI::errstr";
> $dbh->disconnect();
>
> when i execute the above program, get the following error
>
> ************************************************************************************************************************************************
> Can't locate loadable object for module DBI in @INC (@INC contains:
> /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503
> /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .
> /tools/dev/perl_modules/DBI/1.48/DBI-1.48) at
> /tools/dev/perl_modules/DBI/1.48/DBI-1.48/DBI.pm line 254
> BEGIN failed--compilation aborted at
> /tools/dev/perl_modules/DBI/1.48/DBI-1.48/DBI.pm line 254.
> BEGIN failed--compilation aborted at dbp.pl line 7.
>
>
> **********************************************************************************************************************************************
>
> when i check the DBI.pm code
>
> [EMAIL PROTECTED]:[/tools/dev/perl_modules/DBI/1.48/DBI-1.48]> ls -l
> DBI*
> -rwxr-xr-x 1 fftst root 269772 Mar 14 2005 DBI.pm
> -rwxr-xr-x 1 fftst 307 133636 Jan 20 2005 DBI.xs
> -rwxr-xr-x 1 fftst 307 20392 Dec 14 2004 DBIXS.h
> [EMAIL PROTECTED]:[/tools/dev/perl_modules/DBI/1.48/DBI-1.48]>
>
> the comments specified in DBI.pm says
>
> # If you get an error here like "Can't find loadable object ..."
> # then you haven't installed the DBI correctly. Read the README
> # then install it again.
>
> So is this correct? do i need to install it again Or is it something that
> i am missing or not using correctly?
>
> Please do let me know if you need any other info to understand/trouble
> shoot my query
>
>
--
Jonathan Leffler <[EMAIL PROTECTED]> #include <disclaimer.h>
Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
