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

ID: Q198527


The information in this article applies to:
  • Microsoft Site Server version 3.0, Commerce Edition


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 :
Version : WINNT:2.0
Platform : winnt
Issue type : kbprb


Last Reviewed: August 19, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.