DBI::ping hangs after execute failure
- From: ktalinki@xxxxxxxxx (Kumar Talinki)
- Date: Wed, 28 Dec 2005 13:11:09 -0800 (PST)
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
- Prev by Date: RE: DBD-Sybase 1.07, FreeTDS 0.63, HPUX 11.11: Build problem (maketest)
- Next by Date: trying to subclass DBI
- Previous by thread: UNKNOWN OCI STATUS 1804
- Next by thread: trying to subclass DBI
- Index(es):
Relevant Pages
|
|
