Upgrade MS XML

• David.Poole

  SSC Guru

  Points: 76001

  More actions

  September 27, 2002 at 10:09 am

  #158502

  SQL 2000 uses MSXML2.0, is it possible to upgrade this, perhaps to MS XML 4?

  LinkedIn Profile

• earthside

  SSC Enthusiast

  Points: 139

  More actions

  October 18, 2002 at 6:54 pm

  #438934

  I recently installed SQLXML 3.0 on a SQL 2000 server in order to perform XSL Transformations on the server side when I post SQL templates to a virtual directory. It seems to work great.

  I got it here:

  http://msdn.microsoft.com/downloads/default.asp?url=/downloads/sample.asp?url=/msdn-files/027/001/872/msdncompositedoc.xml

  Here's a link to MSXML 4.0 SP1 core:

  http://msdn.microsoft.com/downloads/default.asp?url=/downloads/sample.asp?url=/msdn-files/027/001/766/msdncompositedoc.xml

• Simon Sabin

  SSCrazy Eights

  Points: 8142

  More actions

  October 21, 2002 at 5:47 am

  #438995

  I believe SQL XML 3.0 uses MSXML 4.0 for the IIS side of SQLXML but OPENXML does not use MSXML4.0. This is clear when you try and use some of the new functions in MSXML4.0

  Simon Sabin

  Co-author of SQL Server 2000 XML Distilled

  http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

  
  Simon Sabin
  SQL Server MVP
  
  http://sqlblogcasts.com/blogs/simons