Sorry Guys

2001-12-31 Thread Clinton Hesse
Good old copy and paste an error. Thanks, will make sure the next time i have a problem, not to waste your time for something silly. It's funny, i can call method prepare on the database object but not execute, error on line 3. 1. my $query = "SELECT UserID,Name FROM test"; 2. my

Execute Error

2001-12-31 Thread Clinton Hesse
It's funny, i can call method prepare on the database object but not execute, error on line 3. 1. my $query = "SELECT UserID,Name FROM test"; 2. my $sdb = $dbobj->prepare($query); 3. $dbobj->execute; where $dbobj is a reference to the database object I get error Can't locate object method "exe

MYSQL Database - DBI::db

2001-12-31 Thread Clinton Hesse
i'm using DBI (use DBI;) but I still get this error. Any Ideas. Can't locate object method "execute" via package "DBI::db" (perhaps you forgot to load "DBI::db"?) - Original Message - From: <[EMAIL PROTECTED]> To: "Clinton Hesse"

Access Denied

2001-12-31 Thread Clinton Hesse
I get this error when trying to connect to a mysql database DBI->connect(database=baggs) failed: Access denied for user: 'baggs@localhost' (Using password: YES) I added the user 'baggs' to the user table and to the db privilege table and used mysqladmin reload to refresh the tables. Any Ideas.

Re: DBD::mysql HElp

2001-12-30 Thread Clinton Hesse
Thanks David, I did try DBD::MYSQL but with no success. However I was using active perl's Perl Package Manager. I tried running PPM from the windows command prompt and then install DBI install DBD::mysql Everything installed fine. Thank you. Clinton - Original Message - From: "Davi

DBD::mysql HElp

2001-12-29 Thread Clinton Hesse
> Hi, > > I'm trying to install DBD::MYSQL on Windows 2000 Pro. > I've already install DBI > > Using ppm for ActivePerl > I downloaded DBI and extracted it to a folder. > Then i ran > > ppm> intall DBI > It installed fine. > > I did the exact same thing for DBD::MYSQL but i get the following

DBD::mysql HElp

2001-12-28 Thread Clinton Hesse
Hi, I'm trying to install DBD::MYSQL on Windows 2000 Pro. I've already install DBI Using ppm for ActivePerl I downloaded DBI and extracted it to a folder. Then i ran ppm> intall DBI It installed fine. I did the exact same thing for DBD::MYSQL but i get the following error Error: Package 'DBD