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