I have mysql 4.0.17 apache 1.3.26 and mod_perl 1.29 running on my solaris 8 box.
this is how i install Apache and mod-perl

1. cd mod_perl
2. perl MakeFile.Pl APACHE_SC=../apachexx/src/ DO_HTTPD=1 USE_APACI=1 USE_DSO=1 EVERYTHING=1
3. make
4. make test
5, make install
6. cd apachexx
7. make install

i copied the mysql binary and set up root password...create databases/tables....

It is all woring fine.

Then i install DBD-mysql-2.9003 as follow:
1. perl MakeFile.PL --cflags="-I/usr/local/mysql/include" --libs="-L/usr/local/mysql/lib -lmysqlclient --testpassword="rootpw" --testuser="root"
2. make
3. make test
4. make install

The make test run successfully.
Im using DBI version 1.38

I have two perl version installed.
1. perl 5.0.05_03 built in with solaris 8 this located at /usr/bin
2. perl 5.8.0 I installed later...as i couldnt install mod_perl with the built in perl. and this locate at /usr/local/bin

Both mod_perl and DBD-mysql was compiled using perl 5.8.0

I wrote a small test.html as follow :

use DBI;
for my $drive (DBI->available_drivers){
print "$driver,br/>\n";

And load it on my Apache webserver ..It returned:

when I modified test.html to beome

use DBI;
for my $drive (DBI->available_drivers){
print "$driver,br/>\n";

my $dbh = DBI->connect('DBI:mysql:test:localhost','root','rootpw ', {RaiseError =>1});

my $stm = $dbh->prepare("insert into testac values (134, 'test1')");

When i loaded this on Apache webserver i got from error_log:
[error] Can't locate object "connect" via package "Apache:DBI" at /usr/local/lib/perl5/site_perl/5/8/0/sun4-solaris/DBI.pm line 585.

In httpd.conf file i did included :
SetHandler perl-script
PerlHandler Apache::Registry
PerlModule Apache::DBI
Options +ExecCGI

When i run "find / -name DBI.pm " this is the result:

Does anyone know what the problem is?
Please help