Please do me a favour.

Please do me a favour.

am 04.10.2007 12:29:26 von sivakumarm

Hi,

I have installed Perl 5.6.1 on my windows XP .After that I have written
a small perl script and it run successfully.

When I execute another script(for connecting database and retreiving
data).It is showing DBI error.So I downloaded dbi module DBI-1.59.tar.gz
From the net and copied the DBI folder under the path C:\Program
Files\PERL\lib

Even though it is throwing the error like
"
Can't locate loadable object for module DBI in @INC (@INC contains:
C:/Program F
iles/PERL/lib C:/Program Files/PERL/site/lib .) at C:/Program
Files/PERL/site/li
b/DBI.pm line 243
BEGIN failed--compilation aborted at C:/Program
Files/PERL/site/lib/DBI.pm line
243.
Compilation failed in require at C:\Perl\dbtest.pl line 6.
BEGIN failed--compilation aborted at C:\Perl\dbtest.pl line 6. "

These is my code

#!/opt/perl5.6.1/bin/perl

use strict;
use DBI;

my $dbh =3D DBI->connect( 'dbi:Oracle:omega',
'omega',
'rez5mip2',
);

my $sql =3D qq{ SELECT indiv_firstname, indiv_lastname FROM ind,usr =
WHERE
ind.ind_cd=3Dusr.ind_cd and usr_login=3D'20224474'};
my $sth =3D $dbh->prepare( $sql );
$sth->execute();

while (@row =3D $sth->fetchrow_array) {
($indfirst, $indlast) =3D @row;

print "$indfirst\n";
print "$indlast\n";
}

$sth->finish;
$dbh->disconnect;

Please help me out to reslove this.

Regards
Sivakumar.M