Perl/DBI -> HELP

[c . kearns]

Hello,

O.K we've got a MySQL database and would now like to interact with it using
Perl and DBI.
We've tested that we have Perl by write the good old Hello World script:

#!/usr/bin/perl
print "Hello World!\n";

But now we've moved on by writing this:

#!/usr/bin/perl
vote="$6"
cli="$8"

use DBI;

my $databse_handler = DBI->connect("DBI:mysql:databasename", "username", "password");

# Create SQL statement
$sql = "INSERT INTO votes VALUES ('',NOW(), '$cli', 'pho', '$vote')";

# prepere the statement
$statement_handler = $database_handler->prepare($sql);

# test and execute the statement
if (!defined $statement_handler) {
        die "$DBI::errstr\n";
} else {
        $statement_handler->excute;
}

$statement_handler -> finish;
$database_handler -> disconnect;

print "SN_EVENT_RESULT\n01\n"

But the problem is that this error comes up:

install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains:
/usr/lib/perl5/5.6.0/i386-linux /usr/lib/perl5/5.6.0 /usr/lib/perl5/site_perl/5.
6.0/i386-linux /usr/lib/perl5/site_perl/5.6.0 /usr/lib/perl5/site_perl .) at (ev
al 1) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: ExampleP, Proxy.
 at testDBI.pl line 5

I've tested what drivers we've got installed by write this:

#! /usr/bin/perl -w

use strict;
use DBI;

print "Here's a list of DBI drivers:\n";

my @available_drivers = DBI->available_drivers('quiet');
my $driver;

foreach $driver (@available_drivers)
{
   print "$driver\n";
}

Which only comes up with this:

Here's a list of DBI drivers:
ExampleP
Proxy

How do we go about installing ADO, Multiplex, and MySQL drivers on are
Linux Red Hat 8.0 Server?

Please help.


Chris Kearns (Operations Assistant)

Voice Media Limited

Telephone Number: 01923 815 075

Internal Telephone Number: 2075

Out Of Office Number: 07050 823 823

Fax Number: 01923 815 116

E-Mail: [EMAIL PROTECTED]

Web Site: www.voicemedia.co.uk

*'Figures are purely indicative, for information only and subject to verification'