RE: :ping hangs after execute failure

Sending a trace file (level 9) may help me diagnose the issue.

Jeff


-----Original Message-----
From: Kumar Talinki [mailto:ktalinki@yahoo.com]=20
Sent: Wednesday, December 28, 2005 4:11 PM
To: dbi-users@perl.org
Cc: Kumar Talinki
Subject: DBI::ping hangs after execute failure

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
=20
[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=3D-1)
=20
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.=20
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?
=20
Thanks,
Kumar Talinki
=20
=20