https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/317989&feed=atom&action=history
Microsoft KB Archive/317989 - Revision history
2024-03-29T06:29:01Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/317989&diff=174988&oldid=prev
3155ffGd: importing KB archive
2020-07-18T16:47:59Z
<p>importing KB archive</p>
<p><b>New page</b></p><div><div id="nsbanner"><br />
<br />
<div id="bannerrow1"><br />
<br />
{|<br />
| Knowledge Base<br />
|<br />
|}<br />
<br />
<br />
</div><br />
<div id="TitleRow"><br />
<br />
= <span id="KB317989"></span>FIX: Sqlakw32.dll May Corrupt SQL Statements =<br />
<br />
<br />
</div><br />
<br />
</div><br />
<div id="nstext" valign="BOTTOM"><br />
<br />
Article ID: 317989<br />
<br />
Article Last Modified on 11/2/2007<br />
<br />
<br />
-----<br />
<br />
APPLIES TO<br /><br />
<br /><br />
<br />
* Microsoft SQL Server 2000 Developer Edition<br />
* Microsoft SQL Server 2000 Standard Edition<br />
* Microsoft SQL Server 2000 Enterprise Edition<br />
* Microsoft SQL Server 2000 Personal Edition<br />
* Microsoft SQL Server 2000 Enterprise Edition<br />
* Microsoft SQL Server 2000 Workgroup Edition<br />
* Microsoft SQL Server 2000 Desktop Engine (Windows)<br />
* Microsoft SQL Server 2000 Developer Edition<br />
* Microsoft SQL Server 2000 Enterprise Edition 64-bit<br />
* Microsoft SQL Server 7.0 Standard Edition<br />
<br />
<br />
-----<br />
<br />
<div class="notice_section"><br />
<br />
This article was previously published under Q317989<br />
<br />
</div><br />
<div class="notice_section"><br />
<br />
BUG #: 356597 (SHILOH_BUGS)<br /><br />
BUG #: 58350 (sqlbug_70)<br />
<br />
</div><br />
<div class="symptoms_section"><br />
<br />
== SYMPTOMS ==<br />
<br />
An ESQL/C application may experience all kinds of unexpected errors when opening a cursor:<br />
<ul><br />
<li>An OPEN CURSOR command fails with a syntax error from SQL Server.</li><br />
<li>An OPEN CURSOR command fails with this 16945 error message:<br />
<div class="errormessage"><br />
<br />
The cursor was not declared.<br />
<br />
</div></li><br />
<li>The ESQL cursor does not contain the expected data.</li></ul><br />
<br />
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.<br /><br />
<br /><br />
For example, instead of a line similar to this in the trace<br />
<pre class="codesample">exec sp_cursoropen @P1 output, 'SELECT EmployeeID, LastName, FirstName from employees where EmployeeID = 8', @P3 output, 4, @P5 output </pre><br />
you will see a line similar to this:<br />
<pre class="codesample">exec sp_cursoropen @P1 output, 'SE0', @P3 output, 4, @P5 output </pre><br />
<br />
</div><br />
<div class="resolution_section"><br />
<br />
== RESOLUTION ==<br />
<br />
=== Service pack information ===<br />
<br />
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:<br />
<div class="indent"><br />
<br />
[[../290211|290211]] How to obtain the latest SQL Server 2000 service pack<br />
<br />
<br />
</div><br />
=== Hotfix information ===<br />
<br />
==== Microsoft SQL Server 2000 Service Pack 2 ====<br />
<br />
The English version of the SQL Server 2000 Service Pack 2 fix should have the following file attributes or later:<br />
<pre class="fixed_text"> Date Time Version Size File name<br />
-------------------------------------------------------<br />
26-Feb-02 02:37 8.00.581 126,976 Sqlakw32.dll <br />
</pre><br />
==== Microsoft SQL Server 2000 Service Pack 3 ====<br />
<br />
The English version of the SQL Server 2000 Service Pack 3 fix should have the following file attributes or later:<br />
<pre class="fixed_text"> Date Time Version Size File name<br />
-------------------------------------------------------<br />
19-Feb-2004 09:02 8.00.916 168,001 Sqlakw32.dll<br />
</pre><br />
<br /><br />
'''Note''' Because of file dependencies, the most recent hotfix or feature that contains the files may also contain additional files.<br /><br />
<br /><br />
<br /><br />
<br />
<br />
</div><br />
<div class="status_section"><br />
<br />
== STATUS ==<br />
<br />
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.This problem was first corrected in Microsoft SQL Server 2000 Service Pack 4.<br /><br />
<br /><br />
'''Note''' Although the lower build number may suggest it, this fix is not included in SQL Server 2000 SP3.<br />
<br />
</div><br />
<div class="moreinformation_section"><br />
<br />
== MORE INFORMATION ==<br />
<br />
Please note that ESQL/C is based on the DB-Library API. Therefore, the following paragraph of the &quot;DB-Library API&quot; topic in SQL Books Online applies also to ESQL/C:<br />
<div class="indent"><br />
<br />
&quot;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.&quot;<br />
<br />
<br />
</div><br />
Additionally, please note section 7.0 of the Sp2readme.htm that was included with SQL Server 2000 Service Pack 2:<br />
<div class="indent"><br />
<br />
=== 7.0 DB-Library and Embedded SQL for C ===<br />
<br />
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.<br />
<br />
</div><br />
<br />
</div><br />
Keywords: kbbug kbfix kbqfe kbhotfixserver KB317989<br />
<br />
<div class="footer"><br />
<br />
<br /><br />
<br />
<br />
-----<br />
<br />
[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]<br />
<br />
<span>© Microsoft Corporation. All rights reserved.</span><br />
<br />
<br />
</div><br />
<br />
</div></div>
3155ffGd