Expand|Select|Wrap|Line Numbers
- #!/usr/bin/perl -w
- use DBI;
- #definition of variables
- $db="MYTEST";
- $host="localhost";
- $user="root";
- $password="rootpass";
- #connect to MySQL database
- my $dbh = DBI->connect ("DBI:mysql:database=$db:host=$host:3366",$user,$password)
- or die "Can't connect to database: $DBI::errstr\n";
but this returns with error,
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: C:/Perl/site/lib C:/Perl/lib .
) at (eval 4) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: CSV, DBM, ExampleP, File, Gofer, ODBC, Oracle, Proxy, SQLite, Sponge.
at sample.pl line 11
But I already installed DBD::mysql
C:\Documents and Settings\Administrator>ppm install DBD::mysql
Downloading ActiveState Package Repository packlist...not modified
No missing packages to install
C:\Documents and Settings\Administrator>ppm verify DBD::mysql
ppm verify failed: Package 'DBD::mysql' is not installed
C:\Documents and Settings\Administrator>
I'm using perl version, 5.10.0 built for MSWin32-x86-multi-thread
Any help will be appreciated, Thanks in advanced for all your help