FIX: Handled Exception Error Caused by Server Side Cursors

ID: Q170616

The information in this article applies to:

Microsoft SQL Server version 6.5

BUG #: 16809 (Windows NT: 6.5)

SYMPTOMS

Server side cursors may cause a handled exception error that closes the client thread on the server if all of the following conditions are true:

The cursor contains a text pointer clause.

The cursor's concurrency is set to optimistic.

The cursor type is keyset.

The fetch type is absolute and returns 1 row.

The EXCEPTION_ACCESS_VIOLATION raised is with sp_cursorfetch. This problem occurs when doing a SQLExtendedFetch from a client application, such as Visual Basic or ISQL/W.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 5a for Microsoft SQL Server version 6.5. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

Additional query words: AV Access Violation


Keywords          : kbprg kbusage SSrvGPF SSrvProg SSrvTran_SQL kbbug6.50 kbfix6.50.SP5 
Version           : winnt:6.5
Platform          : winnt 
Issue type        : kbbug

Last Reviewed: April 21, 1999