FIX: XML for SQL Server 2000 Web Release 1 Hotfix Rollup (299423)

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

FIX: XML for SQL Server 2000 Web Release 1 Hotfix Rollup (299423)

SYMPTOMS

RESOLUTION

STATUS