sorry, didn't realize i was logged out for the earlier post..
Tried that but eval didn't capture it. Against my better judgement I put in a 'die' statement next to the execute statement and that seems to work! I would prefer not to have an error handler within an error handler but unfortunately I've burned way too much time troubleshooting 'eval's failrue to capture the error.
eval {
$dbh = DBI->connect("dbi:ODBC:$DSN");
...
$sth->execute() or die "Execute Failed: $!";
$dbh->disconnect();
};
if($@) {
print "DB Failure: $@";
}