DBI::ping hangs after execute failure

--0-564646704-1135804269=:13787
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi,
I am using Active perl 5.8.7.815, SQL Server 2000 / MSDE, and ODBC. When I have a sql execute failure with following error

[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. (SQL-22001)
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. (SQL-01000)(DBD: st_execute/SQLExecute err=-1)

After that failure, I have a DBI::ping call to verify the DB connectivity, which hangs and never returns. I tried to replace DBI::ping with a simple sql statement execute, which also hangs.
Is there anyway I can check the status of $sth or $dbh after the failure? Or any cleanup I need to do after failute? or how can I avoid this kind of hanging problems.
How can I diagnose to see where it is failing?

Thanks,
Kumar Talinki



--0-564646704-1135804269=:13787--