As I understand, Apache:DBI is supposed to be loaded in the mod_perl configuration, not in the script. If Apache::DBI is loaded, use DBI; actually gives you Apache::DBI and its extra feature of connection caching. In all cases, the script should "use DBI;".

If you want to use DBIx::Connector, you will need to read the documentation and possibly change more than just a use line in your script. I have not used it and I do not know about it.