We're getting "Cursor conflict erro

[Quehay]

We're getting "Cursor conflict error" when merely trying to run the UPDATE method against an ADO Forward-Only cursor. This was working last week (and should) but now it's blowing up. We installed a new security hot fix for SQL Server last week. The error still occurs even after rolling the patch back. Here's code:

[tt]'---------------------------------------------------------------------------------------
Function GetNewID

Dim rsID
set rsID=Server.CreateObject("ADODB.Recordset&quot
rsID.ActiveConnection=connectionString
rsID.Source = "SELECT GLOBAL_ID FROM GLOBALS WHERE ID=1"
rsID.CursorType = 1
rsID.CursorLocation = 2
rsID.LockType = 3
rsID.Open
GetNewID = rsID.Fields("GLOBAL_ID&quot.Value + 1
rsID.Fields("GLOBAL_ID&quot.Value = GetNewID
rsID.Update
rsID.Close

Set rsID = Nothing

End Function[/tt]

Thanks in advance!

 

[Quehay]

SOLUTION: SQL Server had NOCOUNT set to ON. This botched ADO's monitoring of inserts, updates, etc.