MySQL/DBI can't locate database!

[woofy]

Hi

I'm a first-timer at DBon

http://WWW using

MySQL & Perl. Rightly or wrongly I have placed a DB in my CGI-BIN however

$dbh = DBI->connect('dbi:mysql:WOOFY_01', '', '',);

cannot connect for

$sqlstatement="SELECT * FROM WOOF";
$sth = $dbh->prepare($sqlstatement);
$sth->execute ||
die "Could not execute SQL statement ... maybe invalid?";

to do its stuff.

Any help would be appreciated.

Cheers [sig][/sig]

 

[tanderso]

# Database Variables
my $db_type = 'mysql'; # RDMS controlling the database
my $db_database = ''; # name of the database
my $db_username = ''; # username to access this database
my $db_password = ''; # password to access this database

# Database API
use DBI;

# Connect to Database
my $drh=DBI->install_driver($db_type);
my $dbh=$drh->connect($db_username,$db_database,$db_password) or die "Error connecting: $DBI::errstr\n";

# Do SQL statements
my $sqlstatement = "SELECT * FROM WOOF";
my $sth = $dbh->prepare($sqlstatement);
$sth->execute || die "Could not execute SQL statement ... maybe invalid?";
my @array = $sth->fetchrow;
$sth->finish;

# Disconnect from database
$dbh->disconnect; [sig]<p> Sincerely,<br><a href=mailto: > </a><br><a href=

http://www.oac-design.com>Tom

Anderson</a><br>CEO, Order amid Chaos, Inc.<br>

http://www.oac-design.com

[/sig]