And which one of your error messages do you see first?

Things to note:

• "Create table" should be done using a "$dbh->do" type command
• You don't do a "$dbh->prepare('commit')", "$dbh->commit" is what you need