Microsoft KB Archive/325687

= Embedded SQL for C Application Fails When It Experiences a Lock Timeout Error =

Article ID: 325687

Article Last Modified on 2/22/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Service Pack 3a
 * Microsoft SQL Server 2000 Service Pack 1
 * Microsoft SQL Server 2000 Service Pack 2

-



This article was previously published under Q325687



SYMPTOMS
A client may receive an access violation error message when the client runs an Embedded SQL (ESQL) statement by following these steps:

 The client runs a SELECT WITH (UPDLOCK ROWLOCK) statement. The LOCK_TIMEOUT period is set to a value other than infinite. After the client runs the query, and before the client retrieves the records, the client checks for the following error:

LOCK TIMEOUT PERIOD EXCEEDED (1222)

The client loops until it exceeds the LOCK_TIMEOUT period and is deemed successful.

When two users try to run the ESQL/C application simultaneously, the user who triggers SQL Server error 1222 receives an access violation error message.



CAUSE
This error occurs because DB-Library does not reset the row status array to zeros, even after DB-Library releases the row data. Therefore, at the time of failure, the row status array incorrectly shows the record count to be greater than zero.



RESOLUTION
A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it to systems that are experiencing this specific problem. This hotfix may 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 immediately, contact Microsoft Product Support Services to obtain the fix. For a complete list of Microsoft Product Support Services phone numbers and information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

NOTE: In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The typical support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

The English version of this fix has the file attributes (or later) 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 tool in Control Panel.

  Date          Time         Version         Size            File name ---  08-Jul-2002   1:45:24 PM   2000.80.656.0   126,976 bytes   Sqlakw32.dll



STATUS
Microsoft has confirmed that this is a problem in DB-Library layer (NTWDBLIB.dll).

Additional query words: ESQL/C AV DB-Library DB-Lib UPDLOCK ROWLOCK

Keywords: kbhotfixserver kbqfe kbbug kberrmsg kbfix kbqfe KB325687

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.