SQL Server error when dropping student from ILT course.

Date: December 9, 2003

Version affected: v1.70, SQLServer

Symptoms:

If a student is assigned to more than on ILT section for a particular course then an error occurs if an attempt is made to drop the student from the course. Only installations using the SQL Server DBMS are affected. A typical example of the error message encountered is:

Module: /v170/asp/slfdrop.asp At: DeleteStudentILTReservations2@0 Statement: delete from cschstud where sched_id=1001 and stud_id=1 Error In: Microsoft OLE DB Provider for ODBC Drivers Error Code: -2147467259 Description: Transaction cannot have multiple recordsets with this cursor type. Change the cursor type, commit the transaction, or close one of the recordsets. SQLState: SQLState: 

Cause:

SQL Server does not allow certain types of SQL queries to be nested while a transaction is in effect.

Correction:

The problem has been corrected (affected queries are no longer nested). New versions of wbtman4a.dll and wbtman4f.dll have been created.

This patch contains a updated versions of:

File
wbtman4a.dll
wbtman4f.dll