FIX: Sqlakw32.dll May Corrupt SQL Statements

Article translations Article translations
Article ID: 317989 - View products that this article applies to.
This article was previously published under Q317989
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 356597 (SHILOH_BUGS)
BUG #: 58350 (sqlbug_70)
Expand all | Collapse all

On This Page

SYMPTOMS

An ESQL/C application may experience all kinds of unexpected errors when opening a cursor:
  • An OPEN CURSOR command fails with a syntax error from SQL Server.
  • An OPEN CURSOR command fails with this 16945 error message:
    The cursor was not declared.
  • The ESQL cursor does not contain the expected data.
To confirm these symptoms, trace the SQL commands in the ESQL application by using SQL Profiler. In the SQL Profiler trace, you will see where corrupted statements were sent to SQL Server.

For example, instead of a line similar to this in the trace
exec sp_cursoropen @P1 output, 'SELECT EmployeeID, LastName, FirstName from employees where EmployeeID = 8', @P3 output, 4, @P5 output				
you will see a line similar to this:
exec sp_cursoropen @P1 output, 'SE0', @P3 output, 4, @P5 output				

RESOLUTION

Service pack information

To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 How to obtain the latest SQL Server 2000 service pack

Hotfix information

Microsoft SQL Server 2000 Service Pack 2

The English version of the SQL Server 2000 Service Pack 2 fix should have the following file attributes or later:
   Date        Time    Version    Size      File name
   -------------------------------------------------------
   26-Feb-02   02:37   8.00.581   126,976   Sqlakw32.dll 
				

Microsoft SQL Server 2000 Service Pack 3

The English version of the SQL Server 2000 Service Pack 3 fix should have the following file attributes or later:
   Date          Time    Version    Size      File name
   -------------------------------------------------------
   19-Feb-2004   09:02   8.00.916   168,001   Sqlakw32.dll
				

Note Because of file dependencies, the most recent hotfix or feature that contains the files may also contain additional files.


STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.This problem was first corrected in Microsoft SQL Server 2000 Service Pack 4.

Note Although the lower build number may suggest it, this fix is not included in SQL Server 2000 SP3.

MORE INFORMATION

Please note that ESQL/C is based on the DB-Library API. Therefore, the following paragraph of the "DB-Library API" topic in SQL Books Online applies also to ESQL/C:
"The DB-Library API has not been enhanced beyond the level of SQL Server version 6.5. All DB-Library applications can work with SQL Server 2000, but only as 6.5 level clients. Features introduced in SQL Server 2000 and SQL Server version 7.0 are not supported for DB-Library applications."
Additionally, please note section 7.0 of the Sp2readme.htm that was included with SQL Server 2000 Service Pack 2:

7.0 DB-Library and Embedded SQL for C

While the DB-Library and Embedded SQL for C application programming interfaces (APIs) are still supported in SQL Server 2000, no future versions of SQL Server will include the files needed to do programming work on applications that use these APIs. Connections from existing applications written using DB-Library and Embedded SQL for C will still be supported in the next version of SQL Server, but this support will also be dropped in a future release. When writing new applications, avoid using these components. When modifying existing applications, you are strongly encouraged to remove dependencies on these technologies. Instead of DB-Library or Embedded SQL for C, you can use ADO, OLE DB, or ODBC to access data in SQL Server. Please refer to SQL Server Books Online for more information on these technologies.

Properties

Article ID: 317989 - Last Review: February 27, 2014 - Revision: 9.4
APPLIES TO
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Personal Edition
  • Microsoft SQL Server 2000, Workgroup Edition
  • Microsoft SQL Server 2000 Desktop Engine (Windows)
  • Microsoft SQL Server 2000 Enterprise Edition 64-bit
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbhotfixserver kbqfe kbqfe kbbug kbfix KB317989

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com