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