Reference to undeclared namespace prefix: ''cmm''. Error processing resource

• pcq0125

  SSCrazy

  Points: 2887

  More actions

  September 7, 2007 at 4:03 pm

  #92760

  HI I am using SQL 2000 XML explicit. I am getting error "Reference to undeclared namespace prefix: 'cmm'. Error processing resource" on the root of the namespace. Below is my code.Can somebody help? Thanks.

   

  select

    1 as Tag

    ,Null as Parent

      ,'http://iip.W3school.com/cmm/xmlns/2005' as [cmm:SubFile!1!xsi:schemaLocation]

    

        For XML explicit

• peterhe

  SSChampion

  Points: 11469

  More actions

  September 27, 2007 at 2:54 pm

  #736930

  I copied your code and ran it on my box, it succeeded with no errors.

  Check your msxml.dll version.

• pcq0125

  SSCrazy

  Points: 2887

  More actions

  September 28, 2007 at 9:20 am

  #737157

  Thanks.