If you're installing the module on your system version of Perl (i.e. the one which was pre-installed as part of your OS) then you're probably best off installing modules using your system's package manager (which would be yum on CentOS).

Something like:

$ sudo yum install perl-DBI perl-DBD-SQLite
[download]

Your post history is a little bit all over the place. Last time you were trying to build a perl of your own to avoid using the system perl. If you've done this successfully you'll need to use cpan which ships with your perl, rather than the system perl. which cpan likely shows the system perl. Examine the previous replies you got about the PATH environment variable. If you are using the system perl now, use your OS package manager as suggested.

If you installed your own perl, you must now start using cpan to install modules. Try this as root: "cpan install DBI" and see what happens. It should install all dependencies needed by DBI first. Watch the terminal and see what transpires as cpan works.... it is quite amazing.