This is the error I get.
DBD::ODBC::st execute failed: ... How can I fix it.

You print the sql statement, and see what's wrong with it. If it doesn't work when you cut and paste it into a SQL query window (or whatever query utility you have), then its not going to work in perl. Maybe you need to quote some/all of your arguments, maybe you should use placeholders (see the DBI docs).