Hi.  I somehow got through apache/perl/mysql installation before but this time... it's 
been very frustrating.  The only difference is i'm on a win 2000 platform now.  Before 
it was win 98.

Everything seems to be ok.  Mysql is running.  I'm certain that the password and 
username are correct in the following script.

my $host = 'localhost';
my $user = 'root';
my $password = 'password';
my $database = 'database_name';
my $dsn = "DBI:mysql:dabase=$database;host=$host;port=3306";
my $dbh = DBI->connect($dsn, $user, $password, {RaiseError => 1}) ||
die "Cannot connect: $DBI::errstr";

everything seems to check out to me, except I keep getting the following when I try to 
prepare the SQL statement:

Can't call method "prepare" on an undefined value

Any help would be much appreciated since I'm out of ideas.  Again, the db exists, 
mysql is running, and the username & password are correct.

I'm also using HTML::Mason but don't see why that would be an issue.

Best,

--Tony

Reply via email to