hi everyone,
I am having a problem getting my Perl program to access a MySQL database.
My test program looks like this:
use DBI;
$serverPort = "3308";
$dbh = DBI->connect('dbi:MySQL:Clients;port=$serverPort',
'mydatabase', 'mypassword');
When I run it with Perl I get the following error:
install_driver(MySQL) failed: Can't locate DBD/MySQL.pm in @INC (@INC
contains: <...snipped...>
Perhaps the DBD::MySQL perl module hasn't been fully installed,
or perhaps the capitalisation of 'MySQL' isn't right.
Available drivers: ADO, ExampleP, Proxy, mysql.
at test.pl line 5
OK that's fine, so I need to change the MySQL to mysql (lowering the
case). So I try this:
use DBI;
$serverPort = "3308";
$dbh = DBI->connect('dbi:mysql:Clients;port=$serverPort',
'mydatabase', 'mypassword');
But this time I get the following, which is where I get stuck:
install_driver(mysql) failed: Can't find 'boot_DBD__mysql' symbol in
/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so
at (eval 1) line 3
at test.pl line 5
...so, what on earth does this last error mean?
My ISP told me they noticed no problems when they installed the MySQL
module for Perl. Do any of you have any idea what this error message
means?
any help is hugely appreciated!
- Brendan
