in reply to DBI to ODBC

You have two problems. The first is the semicolon at the end of the SQL Statement. The second is that the * needs to be a %. The ODBC wildcard is the percent sign.