MSXML VBA: XML Validation on XSD: "The existing namespace is different from the targetNamespace schema."

Question

I am trying to check the .XML file for the .XSD file with the MSXML 6.0 DOM, but when I run the code, Im getting this error message:

Test.xsd#/schema/targetNamespace[1] "The '' namespace provided differs from the schema 'http://somewhere.com/root' targetNamespace." 

In very simplified versions of .XML and .XSD files, the same errors also occur:

XML FILE

 <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <ns2:noderoot xmlns:ns2="http://somewhere.com/root"> <general> <year>2011</year> <month>02</month> </general> </ns2:noderoot> 

Xsd file

 <?xml version="1.0" encoding="UTF-8"?> <xs:schema xmlns="http://somewhere.com/root" targetNamespace="http://somewhere.com/root" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" elementFormDefault="unqualified" attributeFormDefault="unqualified"> <xs:complexType name="TYPE_nodeGeneral"> <xs:sequence> <xs:element name="year"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:length value="4"/> <xs:pattern value="\d{4}"/> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="month"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:length value="2"/> </xs:restriction> </xs:simpleType> </xs:element> </xs:sequence> </xs:complexType> <xs:complexType name="TYPE_noderoot"> <xs:sequence> <xs:element name="general" type="TYPE_nodeGeneral"></xs:element> </xs:sequence> </xs:complexType> <xs:element name="noderoot" type="TYPE_noderoot"></xs:element> </xs:schema> 

To validate the Im XML file using this code written in VBA (Excel 2010):

 Sub XSD_Validation() XML_FILE = "I:\Test.xml" XSD_FILE = "I:\Test.xsd" Dim xmlDoc As MSXML2.DOMDocument60 Set xmlDoc = New MSXML2.DOMDocument60 xmlDoc.async = False xmlDoc.validateOnParse = False xmlDoc.resolveExternals = False xmlDoc.Load XML_FILE ' Open XSD file Dim obXSD As MSXML2.DOMDocument60 Set objXSD = New MSXML2.DOMDocument60 objXSD.async = False objXSD.Load XSD_FILE ' Populate schema cache Dim objSchemaCache As XMLSchemaCache60 Set objSchemaCache = New MSXML2.XMLSchemaCache60 objSchemaCache.Add "", objXSD ' XSD XML Bind Set xmlDoc.Schemas = objSchemaCache 'Error visualization Dim objErr As MSXML2.IXMLDOMParseError Set objErr = xmlDoc.Validate() If objErr.errorCode <> 0 Then Debug.Print "Error parser: " & objErr.errorCode & "; " & objErr.reason Else Debug.Print "No errors found" End If Set objErr = Nothing Set objXSD = Nothing Set objSchemaCache = Nothing Set xmlDoc = Nothing End Sub 

The XSD file can be modified, but the XML file must remain untouched.

I tried to solve this problem for more than 8 hours without a positive result.

Any help would be greatly appreciated.

Answer 1

Try adding the namespace URI to the schema cache.

 Sub XSD_Validation() Dim xmlDoc As MSXML2.DOMDocument60 Dim objSchemaCache As New XMLSchemaCache60 Dim objErr As MSXML2.IXMLDOMParseError objSchemaCache.Add "http://somewhere.com/root", LoadXmlFile("I:\Test.xsd") Set xmlDoc = LoadXmlFile("I:\Test.xml") Set xmlDoc.Schemas = objSchemaCache Set objErr = xmlDoc.Validate() If objErr.errorCode = 0 Then Debug.Print "No errors found" Else Debug.Print "Error parser: " & objErr.errorCode & "; " & objErr.reason End If End Sub Function LoadXmlFile(Path As String) As MSXML2.DOMDocument60 Set LoadXmlFile = New MSXML2.DOMDocument60 With LoadXmlFile .async = False .validateOnParse = False .resolveExternals = False .load Path End With End Function 

Answer 2

You do not need to change anything in xml / xsd, since together they are valid. The problem is your code, so I would suggest taking a look at this sample , which shows what I think is different from your code: when you add XSD to the cache, use the target namespace http://somewhere.com/root instead of the target line .