Sending a trace file (level 9) may help me diagnose the issue. Jeff
-----Original Message----- From: Kumar Talinki [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 28, 2005 4:11 PM To: [email protected] 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 [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
