Hi Jonjathan, First of all Thank you very much for the quick response, i tried with modified path you mentioned and also blib, it did not work. I think the DBI is not installed properly, our admin might have did just unzipped the files, may not have done "make", let me clarify with them, because this is the first perl code i am writing here in my org, so this might be the confusion, let me check and come back to you if i still have any doubts. Again thanks for your help
Warm Regards Srinivas Katti [EMAIL PROTECTED] 07/29/2008 04:09 AM To Srinivas KATTI/ia/[EMAIL PROTECTED] cc [email protected] Subject Re: Perl+DBI question [C1] 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." ************************************************************************* This message and any attachments (the "message") are confidential, intended solely for the addressee(s), and may contain legally privileged information. Any unauthorised use or dissemination is prohibited. E-mails are susceptible to alteration. Neither SOCIETE GENERALE nor any of its subsidiaries or affiliates shall be liable for the message if altered, changed or falsified. ************ Ce message et toutes les pieces jointes (ci-apres le "message") sont confidentiels et susceptibles de contenir des informations couvertes par le secret professionnel. Ce message est etabli a l'intention exclusive de ses destinataires. Toute utilisation ou diffusion non autorisee est interdite. Tout message electronique est susceptible d'alteration. La SOCIETE GENERALE et ses filiales declinent toute responsabilite au titre de ce message s'il a ete altere, deforme ou falsifie. *************************************************************************
