Microsoft KB Archive/299423

= FIX: XML for SQL Server 2000 Web Release 1 Hotfix Rollup =

Article ID: 299423

Article Last Modified on 9/26/2005

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q299423



SYMPTOMS
A hotfix rollup for XML for SQL Server 2000 Web Release 1 is now available, which alleviates most of the issues that you may encounter with XML when you use SQL Server 2000. The XML for SQL Server 2000 Web Release 1 Hotfix Rollup includes the following fixes:

 XML Bulk Load

In SQL Server 2000 Web Release 1, when bulk loading in transactional mode and connecting to a database by using a connection string, an error sometimes occurs, which reports that a COMMIT TRANSACTION statement was issued without a corresponding BEGIN TRANSACTION statement.

 MSXML 4.0 Issue

In SQL Server 2000 Web Release 1 with MSXML 4.0 (currently in beta) installed, the templates that use mapping schemas and XPath queries fail and return this error message:

XXX is an Invalid or Unsupported XPATH

where XXX is your XPATH query.

 SQLISAPI

In SQL Server 2000 Web Release 1, the ISAPI extension, instead of returning an error message when it fails to impersonate the logged on user, continues to process a request by using the local system account. Now, if the function fails, an error message occurs.

In SQL Server 2000 Web Release 1, when URL parameter values contain encoded characters, such as %xx, data corruption of the parameter values can occur.



RESOLUTION
This supported hotfix rollup is now available from Microsoft, but it is only intended to correct the problems described in this article and should be applied only to systems experiencing these specific problems.

To acquire this hotfix rollup immediately, contact Microsoft Product Support Services. For a complete list of Microsoft Product Support Services phone numbers and information about support costs, please go to the following address on the World Wide Web:

http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS

NOTE: In special cases, charges that are normally incurred for support calls may be canceled, if a Microsoft Support Professional determines that a specific update will resolve your problem. Normal 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 should have the following file attributes or later:   Date          Version          Size             File name

05/17/2001   2000.80.401.0     53,828 bytes    Sqlisapi.dll 05/17/2001   2000.80.401.0    221,768 bytes    Sqlvdir.dll 05/17/2001   2000.80.401.0    213,072 bytes    Sqlxmlx.dll 05/17/2001   2000.80.401.0    160,324 bytes    Xmlblkld.dll To install this hotfix rollup, run Q299423_SQLXML_WR1_en.exe. The installation procedure overwrites the files for XML for SQL Server 2000 Web Release 1.

Q299423_SQLXML_WR1_en.exe installs these files in the following locations on your computer:

C:\Program Files\Common Files\System\OLE DB    Sqlisapi.dll Sqlxmlx.dll Xmlblkld.dll

C:\Program Files\Microsoft SQL Server\80\Tools\Binn Sqlvdir.dll

C:\Program Files\XML for SQL\Documents Sqlxmlwr2.chm Readme.htm



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

Additional query words: sqlxml sqlxmlx sqlvdir xmlblkld sqlisapi qfe hotfix rollup

Keywords: kbbug kbfix kbqfe kbhotfixserver KB299423

-

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

© Microsoft Corporation. All rights reserved.