in reply to perl DBI error
We really would need to see the query you are passing to prepare as the error code SQL-42000 indicates simply Syntax error or access violation
/J\