Compiling perl 5.8.8 for using DBI

[jmishra]

Hi,
I am compiling perl 5.8 on i386-linux architecture,every thing went fine
and I am able to execute normal perl scripts thorugh this newly built perl.
But when I try to execute script which has postgres database access statement it gives me following error :

"Can't locate object method "connect" via package "DBI" (perhaps you forgot to load "DBI"?)"

Note that I have DBI and DBD modules installed and I able able to access postgress database through the perl which comes default with fedora core 6 installation.
The perl which I have built is giving the error.
Please let me know what I need to build extra to acces database.
Would appriciate if anyone can post all the steps to build perl (including configuration parameteres and make options).

Thanks,

[eWish]

Did you include the following in your script?

use DBI;

--Kevin

[jmishra]

Hi Kevin,
Following is the script which I am trying to use:

use DBI;
 
$user     = "emulator";
$password = "";
$dbname   = "nocc532";
#$ENV{PGHOST} = 'delphi.medic.chalmers.se';
 
$dbh = DBI->connect("dbi:Pg:dbname=$dbname", $user, $password);
$sth  = $dbh->prepare("select * from dictionary");
$sth->execute;
 
while ( @row = $sth->fetchrow_array ) {
         print "@row\n";
       }
 
$dbh->disconnect;
 

Regards