Help and Support

On a computer that is running Windows Vista, Windows Server 2008, or Windows XP, an incorrect value is returned when an application queries the identity column value of a newly inserted row in various versions of SQL Server 2005 and of SQL Server 2000

View products that this article applies to.
Article ID:951937
Last Review:May 2, 2008
Revision:1.2
On This Page

SYMPTOMS

Applications that use the ActiveX Data Objects (ADO) interface in the following scenario may experience functionality issues:
•An application connects to Microsoft SQL Server 2005, to SQL Server 2005 Express Edition, to Microsoft SQL Server 2000, or to SQL Server Desktop Engine (also known as MSDE 2000).
•The application uses the SET NOCOUNT ON statement for the connection.
•The application inserts a row into a table that has an identity column by using a Microsoft ActiveX Data Objects (ADO) client-side cursor.

Note This issue only occurs if the application uses a client-side cursor. If the application uses a server-side cursor, the application is not affected.
When the application queries the identity column value of the newly inserted row, the value "0" is returned incorrectly. This may cause an application to malfunction or even data loss. Whether a malfunction or data loss occurs depends on how the application handles this scenario.

This problem exists in the Microsoft Data Access Components (MDAC) components of the following Windows operating systems:
•Windows Vista Service Pack 1
• Windows XP Service Pack 2 with hotfix 940569
•Windows XP Service Pack 3
•Windows Server 2008
To prevent this problem, install the hotfix that is described in this article.

Back to the top

RESOLUTION

Hotfix information

Windows Vista Service Pack 1 or Windows Server 2008

A supported hotfix is now available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next service pack that contains this hotfix.

To resolve this problem, submit a request to Microsoft Online Customer Services to obtain the hotfix. To submit an online request to obtain the hotfix, visit the following Microsoft Web site:
http://go.microsoft.com/?linkid=6294451 (http://go.microsoft.com/?linkid=6294451)
Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. To create a separate service request, visit the following Microsoft Web site:
http://support.microsoft.com/contactus/?ws=support (http://support.microsoft.com/contactus/?ws=support)
Prerequisites
To apply this hotfix, you must have Windows Vista Service Pack 1 or Windows Server 2008 installed on the computer.
Restart requirement
You do not have to restart the computer after you apply this hotfix.
Hotfix replacement information
This hotfix does not replace any other previously released hotfixes.
Registry information
To use this hotfix, you do not have to make any changes to the registry.
File information
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

Windows Vista with SP1 or Windows Server 2008, x86-based versions
File nameFile versionFile sizeDateTimePlatform
Package_1_for_kb951937~31bf3856ad364e35~x86~~6.0.1.0.mumNot Applicable1,98524-Apr-200817:30Not Applicable
Package_2_for_kb951937~31bf3856ad364e35~x86~~6.0.1.0.mumNot Applicable1,82324-Apr-200817:30Not Applicable
Package_3_for_kb951937~31bf3856ad364e35~x86~~6.0.1.0.mumNot Applicable1,82324-Apr-200817:30Not Applicable
Package_for_kb951937_client_1~31bf3856ad364e35~x86~~6.0.1.0.mumNot Applicable1,36724-Apr-200817:30Not Applicable
Package_for_kb951937_client~31bf3856ad364e35~x86~~6.0.1.0.mumNot Applicable1,43024-Apr-200817:30Not Applicable
Package_for_kb951937_sc_0~31bf3856ad364e35~x86~~6.0.1.0.mumNot Applicable1,42124-Apr-200817:30Not Applicable
Package_for_kb951937_sc~31bf3856ad364e35~x86~~6.0.1.0.mumNot Applicable1,42224-Apr-200817:30Not Applicable
Package_for_kb951937_server_0~31bf3856ad364e35~x86~~6.0.1.0.mumNot Applicable1,42524-Apr-200817:30Not Applicable
Package_for_kb951937_server~31bf3856ad364e35~x86~~6.0.1.0.mumNot Applicable1,43024-Apr-200817:30Not Applicable
Update.mumNot Applicable2,58024-Apr-200817:30Not Applicable
X86_abe633cc9668eadbe23782cdce2965cc_31bf3856ad364e35_6.0.6001.22166_none_c3cb61880075f656.manifestNot Applicable73824-Apr-200817:30Not Applicable
X86_microsoft-windows-m..nts-mdac-rds-ce-dll_31bf3856ad364e35_6.0.6001.22166_none_623fb3925b080f30.manifestNot Applicable15,00124-Apr-200805:16Not Applicable
Msadce.dll6.0.6001.22166454,65624-Apr-200804:42x86
Windows Vista with SP1 or Windows Server 2008, x64-based versions
File nameFile versionFile sizeDateTimePlatform
Amd64_2712aba765c6f92e3b4baaf06f2e9334_31bf3856ad364e35_6.0.6001.22166_none_44c0a311b1f35595.manifestNot Applicable1,12424-Apr-200817:30Not Applicable
Amd64_microsoft-windows-m..nts-mdac-rds-ce-dll_31bf3856ad364e35_6.0.6001.22166_none_be5e4f1613658066.manifestNot Applicable14,68324-Apr-200811:38Not Applicable
Package_1_for_kb951937~31bf3856ad364e35~amd64~~6.0.1.0.mumNot Applicable2,25324-Apr-200817:30Not Applicable
Package_2_for_kb951937~31bf3856ad364e35~amd64~~6.0.1.0.mumNot Applicable2,08924-Apr-200817:30Not Applicable
Package_3_for_kb951937~31bf3856ad364e35~amd64~~6.0.1.0.mumNot Applicable2,08924-Apr-200817:30Not Applicable
Package_for_kb951937_client_1~31bf3856ad364e35~amd64~~6.0.1.0.mumNot Applicable1,37524-Apr-200817:30Not Applicable
Package_for_kb951937_client~31bf3856ad364e35~amd64~~6.0.1.0.mumNot Applicable1,43824-Apr-200817:30Not Applicable
Package_for_kb951937_sc_0~31bf3856ad364e35~amd64~~6.0.1.0.mumNot Applicable1,42924-Apr-200817:30Not Applicable
Package_for_kb951937_sc~31bf3856ad364e35~amd64~~6.0.1.0.mumNot Applicable1,43024-Apr-200817:30Not Applicable
Package_for_kb951937_server_0~31bf3856ad364e35~amd64~~6.0.1.0.mumNot Applicable1,43324-Apr-200817:30Not Applicable
Package_for_kb951937_server~31bf3856ad364e35~amd64~~6.0.1.0.mumNot Applicable1,43824-Apr-200817:30Not Applicable
Update.mumNot Applicable2,59824-Apr-200817:30Not Applicable
Msadce.dll6.0.6001.22166589,82424-Apr-200805:08x64
Windows Vista with SP1 or Windows Server 2008, Itanium-based versions
File nameFile versionFile sizeDateTimePlatform
Ia64_7416acfc5d9273e2a12739c9c1703f11_31bf3856ad364e35_6.0.6001.22166_none_52eec04c8f1fd622.manifestNot Applicable1,12224-Apr-200817:30Not Applicable
Ia64_microsoft-windows-m..nts-mdac-rds-ce-dll_31bf3856ad364e35_6.0.6001.22166_none_624157885b06182c.manifestNot Applicable14,66724-Apr-200805:24Not Applicable
Package_1_for_kb951937~31bf3856ad364e35~ia64~~6.0.1.0.mumNot Applicable2,08424-Apr-200817:30Not Applicable
Package_2_for_kb951937~31bf3856ad364e35~ia64~~6.0.1.0.mumNot Applicable2,08424-Apr-200817:30Not Applicable
Package_for_kb951937_sc_0~31bf3856ad364e35~ia64~~6.0.1.0.mumNot Applicable1,42524-Apr-200817:30Not Applicable
Package_for_kb951937_sc~31bf3856ad364e35~ia64~~6.0.1.0.mumNot Applicable1,42624-Apr-200817:30Not Applicable
Package_for_kb951937_server_0~31bf3856ad364e35~ia64~~6.0.1.0.mumNot Applicable1,42924-Apr-200817:30Not Applicable
Package_for_kb951937_server~31bf3856ad364e35~ia64~~6.0.1.0.mumNot Applicable1,43424-Apr-200817:30Not Applicable
Update.mumNot Applicable1,92224-Apr-200817:30Not Applicable
Msadce.dll6.0.6001.221661,175,55224-Apr-200804:50IA-64

Windows XP

A supported hotfix is now available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next Windows XP service pack that contains this hotfix.

To resolve this problem, submit a request to Microsoft Online Customer Services to obtain the hotfix. To submit an online request to obtain the hotfix, visit the following Microsoft Web site:
http://go.microsoft.com/?linkid=6294451 (http://go.microsoft.com/?linkid=6294451)
Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. To create a separate service request, visit the following Microsoft Web site:
http://support.microsoft.com/contactus/?ws=support (http://support.microsoft.com/contactus/?ws=support)
Prerequisites
To apply this hotfix, you must have Windows XP Service Pack 2 or Service Pack 3 installed on the computer.
Restart requirement
You do not have to restart the computer after you apply this hotfix.
Hotfix replacement information
This hotfix does not replace any other previously released hotfixes.
Registry information
To use this hotfix, you do not have to make any changes to the registry.
File information
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

Windows XP with SP2, x86-based versions
File nameFile versionFile sizeDateTime
Msadce.dll2.81.1134.0331,77624-Apr-200814:20
Windows XP with SP3, x86-based versions
File nameFile versionFile sizeDateTime
Msadce.dll2.81.3001.0331,77624-Apr-200814:04

Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Back to the top

MORE INFORMATION

Customers who use Microsoft Dynamics Retail Management System (RMS) Store Operations and Headquarters are affected by this issue when they use the Windows operating systems that are affected and supported. We recommend that you install this hotfix to prevent potentially invalid data or data loss.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:
824684 (http://support.microsoft.com/kb/824684/) Description of the standard terminology that is used to describe Microsoft software updates

Back to the top

APPLIES TO
•Windows Vista Service Pack 1, when used with:
  Windows Vista Enterprise 64-bit Edition
  Windows Vista Home Basic 64-bit Edition
  Windows Vista Home Premium 64-bit Edition
  Windows Vista Ultimate 64-bit Edition
  Windows Vista Business
  Windows Vista Business 64-bit Edition
  Windows Vista Enterprise
  Windows Vista Home Basic
  Windows Vista Home Premium
  Windows Vista Ultimate
•Windows Server 2008 Datacenter without Hyper-V
•Windows Server 2008 Enterprise without Hyper-V
•Windows Server 2008 for Itanium-Based Systems
•Windows Server 2008 Standard without Hyper-V
•Windows Server 2008 Datacenter
•Windows Server 2008 Enterprise
•Windows Server 2008 Standard
•Microsoft Windows XP Service Pack 3

Back to the top

Keywords: 
kbexpertiseadvanced kbfix kbqfe kbhotfixserver KB951937

Back to the top

Article Translations

 

Other Support Options

  • Contact Microsoft
    Phone Numbers, Support Options and Pricing, Online Help, and more.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.