Knowledge Base

Err Msg: [Microsoft][ODBC SQL Server Driver] Cursor Concurrency Changed

Article ID: 198527

Article Last Modified on 6/28/2004

Microsoft Site Server 3.0 Commerce Edition

This article was previously published under Q198527

SYMPTOMS

This article pertains to the Site Server 3.0 Commerce Edition Sample Site - MS Market interoperability with Microsoft Visual InterDev (VID) 6.0.

The following error occurs when you attempt to delete a Part, Part Class, Req Class, or Vendor in the Market Manager pages on a server that has Visual InterDev 6.0 installed:

[Microsoft][ODBC SQL Server Driver] Cursor concurrency changed

MS Market is falsely interpreting this informational message from the SQL Server driver as an error.

CAUSE

The problem is that the updated database components shipped with VID 6.0 now return an informational message in the recordset.activeconnection.errors collection. Market goes through this collection and if it finds an error, it displays an error dialog to the user. No other Commerce sample sites check for entries in this collection.

WORKAROUND

To work around this problem, change the cursor type to adOpenForwardOnly instead of adOpenKeyset in Market's Manager/_delete.asp file. This will prevent the informational message from appearing in the errors collection.

Additional query words: hotfix hot fix qfe quick fix engineering patch

Keywords: kbprb KB198527