Dear Monks,
Can anyone please explain the following error message? My usual coding strategies do not overcome this error. I have to delete the SQL statement prior to the SQL statement that comes up in this error statement. I think that it is a weakness of MS SQL Server or Perl DBI rather than my code.
DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver]Conne
+ction is b
usy with results for another hstmt (SQL-HY000)(DBD: st_execute/SQLExec
+ute err=-1
) at table_ZK.pl line 846.
Couldn't execute query: [Microsoft][ODBC SQL Server Driver]Connection
+is busy wi
th results for another hstmt (SQL-HY000)(DBD: st_execute/SQLExecute er
+r=-1) at table_ZK.pl line 846.
20040127 Edit by BazB: Changed title from 'Error message'