Problem Note 33797: An error occurs when you update an SQL Server table that contains triggers
 |  |  |  |
When you use SAS/ACCESS® Interface to Microsoft SQL Server to update an SQL Server table that contains triggers, the following error is returned:
ERROR: CLI cursor fetch error: [DataDirect][ODBC SQL Server Driver]Connection is busy with results for another hstmt
This error occurs because an update trigger that is defined in the SQL Server table generates multiple results during the update process.
The SQL Server database only permits one active statement per connection, and an active result (most like a row count) might already exist. As a result, the next fetch to process the next update returns the error message.
As a workaround, you can use the following SQL Server option at the top of the trigger code:
set nocount on
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Microsoft SQL Server | 64-bit Enabled Solaris | 9.2 TS1M0 | 9.3 TS1M0 |
| HP-UX IPF | 9.2 TS1M0 | 9.3 TS1M0 | ||
| Linux for x64 | 9.2 TS1M0 | 9.3 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.2 TS1M0 | 9.3 TS1M0 | ||
| 64-bit Enabled AIX | 9.2 TS1M0 | 9.3 TS1M0 | ||
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2008-11-05 09:38:09 |
| Date Created: | 2008-10-30 14:48:11 |