Bizarre XSD File Format Changes with Web Developer?

[Don Miller]

I have a bizarre problem when I try to validate XML documents and their
schemas once they have been opened and transfered to a Visual Web Developer
2005 Express project. I receive validation errors for XML/XSDs that worked
fine when first created in another environment (XMLSpy trial).

I have a source XML document and an XSD file created wtih XMLSpy and stored
in a separate folder. When I run a very simple VBScript to validate the XML
with the XSD (in the process of a bulkload to SQL Server with
SQLXMLBulkload. 4.0), there are no validation errors, and the load to the DB
works perfectly.

When I try to use the exact same VBScript to bulkload copies of the same
files from before, which were duplicated and added to a Visual Web Developer
project, I get validation errors like

"Schema: unable to load schema 'XXXX'. An error occurred (Text is not
allowed in the context of
element'{http://www.w3.org/2001/XMLSchema}seque nce' according to DTD/Schema"

And then I get a validation error for a simple type like:

'DANNER' violates length constraint of ' 50'
The element 'LastName' with value 'DANNER' failed to parse.

with the source <LastName>Danne r</LastNamefor the simple type below

<xs:simpleTyp e name="VARCHAR_5 0">
<xs:restricti on base="xs:string ">
<xs:length value="50"/>
</xs:restriction>
</xs:simpleType>

So, it seems like the XSD file has been changed somehow and cannot be parsed
or is stricter???? Are there changes to the encoding or whitespace when an
XSD file is opened/transferred to Visual Web Developer 2005 Express?

Thanks for any help.

[John Saunders [MVP]]

"Don Miller" <no****@nospam. comwrote in message
news:u3******** ******@TK2MSFTN GP04.phx.gbl...

>I have a bizarre problem when I try to validate XML documents and their
schemas once they have been opened and transfered to a Visual Web Developer
2005 Express project. I receive validation errors for XML/XSDs that worked
fine when first created in another environment (XMLSpy trial).

I have a source XML document and an XSD file created wtih XMLSpy and
stored in a separate folder. When I run a very simple VBScript to validate
the XML with the XSD (in the process of a bulkload to SQL Server with
SQLXMLBulkload. 4.0), there are no validation errors, and the load to the
DB works perfectly.

When I try to use the exact same VBScript to bulkload copies of the same
files from before, which were duplicated and added to a Visual Web
Developer project, I get validation errors like

"Schema: unable to load schema 'XXXX'. An error occurred (Text is not
allowed in the context of
element'{http://www.w3.org/2001/XMLSchema}seque nce' according to
DTD/Schema"

And then I get a validation error for a simple type like:

'DANNER' violates length constraint of ' 50'
The element 'LastName' with value 'DANNER' failed to parse.

with the source <LastName>Danne r</LastNamefor the simple type below

<xs:simpleTyp e name="VARCHAR_5 0">
<xs:restricti on base="xs:string ">
<xs:length value="50"/>
</xs:restriction>
</xs:simpleType>

So, it seems like the XSD file has been changed somehow and cannot be
parsed or is stricter???? Are there changes to the encoding or whitespace
when an XSD file is opened/transferred to Visual Web Developer 2005
Express?

Have you tried to compare the original XSD vs. the one in Visual Web
Developer? In what way has it changed?
--
John Saunders [MVP]

[Don Miller]

Have you tried to compare the original XSD vs. the one in Visual Web

Developer? In what way has it changed?

They were identical. I opened the original in NotePad, selected and copied
the text, opened the copy in Visual Web Developer and pasted it in, saved
it, and now that part seems to work. I don't know why.

But when I try to validate my XML file before BulkLoading using a
ValidateFile function
(http://msdn2.microsoft.com/en-us/library/ms171806.aspx) from MS I still get
the

'DANNER' violates length constraint of ' 50'
The element 'LastName' with value 'DANNER' failed to parse.

for an element like this <LastName>DANNE R</LastNamewhere the XSD uses a
derived type

<xs:simpleTyp e name="VARCHAR_5 0">

<xs:restricti on base="xs:string ">

<xs:length value="50"/>

</xs:restriction>

</xs:simpleType>

<xs:element name="LastName" type="VARCHAR_5 0" sql:datatype="v archar"/>

This is probably an entirely separate problem, something to do with
MSXML2.XMLSchem aCache.6.0 and MSXML2.DOMDocum ent.6.0 objects and not because
of Web Developer. If I susbstitute type="xs:string " instead of VARCHAR_50 it
works but I lose my pre-load checking. But with this parse error, if I
ignore it and continue with the bulkload, the load still works! Any ideas???


"John Saunders [MVP]" <john.saunder s at trizetto.comwro te in message
news:Op******** *****@TK2MSFTNG P06.phx.gbl...

"Don Miller" <no****@nospam. comwrote in message
news:u3******** ******@TK2MSFTN GP04.phx.gbl...

>>I have a bizarre problem when I try to validate XML documents and their
schemas once they have been opened and transfered to a Visual Web
Developer 2005 Express project. I receive validation errors for XML/XSDs
that worked fine when first created in another environment (XMLSpy trial).

I have a source XML document and an XSD file created wtih XMLSpy and
stored in a separate folder. When I run a very simple VBScript to
validate the XML with the XSD (in the process of a bulkload to SQL Server
with SQLXMLBulkload. 4.0), there are no validation errors, and the load to
the DB works perfectly.

When I try to use the exact same VBScript to bulkload copies of the same
files from before, which were duplicated and added to a Visual Web
Developer project, I get validation errors like

"Schema: unable to load schema 'XXXX'. An error occurred (Text is not
allowed in the context of
element'{htt p://www.w3.org/2001/XMLSchema}seque nce' according to
DTD/Schema"

And then I get a validation error for a simple type like:

'DANNER' violates length constraint of ' 50'
The element 'LastName' with value 'DANNER' failed to parse.

with the source <LastName>Danne r</LastNamefor the simple type below

<xs:simpleTy pe name="VARCHAR_5 0">
<xs:restricti on base="xs:string ">
<xs:length value="50"/>
</xs:restriction>
</xs:simpleType>

So, it seems like the XSD file has been changed somehow and cannot be
parsed or is stricter???? Are there changes to the encoding or whitespace
when an XSD file is opened/transferred to Visual Web Developer 2005
Express?

Have you tried to compare the original XSD vs. the one in Visual Web
Developer? In what way has it changed?
--
John Saunders [MVP]

[Don Miller]

Oops! Apparently <xs:length value="50"/means the element text MUST be 50
characters long. <xs:maxLength value="50"/does the trick.
"Don Miller" <no****@nospam. comwrote in message
news:%2******** ********@TK2MSF TNGP02.phx.gbl. ..

>Have you tried to compare the original XSD vs. the one in Visual Web
Developer? In what way has it changed?

They were identical. I opened the original in NotePad, selected and copied
the text, opened the copy in Visual Web Developer and pasted it in, saved
it, and now that part seems to work. I don't know why.

But when I try to validate my XML file before BulkLoading using a
ValidateFile function
(http://msdn2.microsoft.com/en-us/library/ms171806.aspx) from MS I still
get the

'DANNER' violates length constraint of ' 50'
The element 'LastName' with value 'DANNER' failed to parse.

for an element like this <LastName>DANNE R</LastNamewhere the XSD uses a
derived type

<xs:simpleTyp e name="VARCHAR_5 0">

<xs:restricti on base="xs:string ">

<xs:length value="50"/>

</xs:restriction>

</xs:simpleType>

<xs:element name="LastName" type="VARCHAR_5 0" sql:datatype="v archar"/>

This is probably an entirely separate problem, something to do with
MSXML2.XMLSchem aCache.6.0 and MSXML2.DOMDocum ent.6.0 objects and not
because of Web Developer. If I susbstitute type="xs:string " instead of
VARCHAR_50 it works but I lose my pre-load checking. But with this parse
error, if I ignore it and continue with the bulkload, the load still
works! Any ideas???


"John Saunders [MVP]" <john.saunder s at trizetto.comwro te in message
news:Op******** *****@TK2MSFTNG P06.phx.gbl...

>"Don Miller" <no****@nospam. comwrote in message
news:u3******* *******@TK2MSFT NGP04.phx.gbl.. .

>>>I have a bizarre problem when I try to validate XML documents and their
schemas once they have been opened and transfered to a Visual Web
Developer 2005 Express project. I receive validation errors for XML/XSDs
that worked fine when first created in another environment (XMLSpy
trial).

I have a source XML document and an XSD file created wtih XMLSpy and
stored in a separate folder. When I run a very simple VBScript to
validate the XML with the XSD (in the process of a bulkload to SQL
Server with SQLXMLBulkload. 4.0), there are no validation errors, and the
load to the DB works perfectly.

When I try to use the exact same VBScript to bulkload copies of the same
files from before, which were duplicated and added to a Visual Web
Developer project, I get validation errors like

"Schema: unable to load schema 'XXXX'. An error occurred (Text is not
allowed in the context of
element'{http ://www.w3.org/2001/XMLSchema}seque nce' according to
DTD/Schema"

And then I get a validation error for a simple type like:

'DANNER' violates length constraint of ' 50'
The element 'LastName' with value 'DANNER' failed to parse.

with the source <LastName>Danne r</LastNamefor the simple type below

<xs:simpleTyp e name="VARCHAR_5 0">
<xs:restricti on base="xs:string ">
<xs:length value="50"/>
</xs:restriction>
</xs:simpleType>

So, it seems like the XSD file has been changed somehow and cannot be
parsed or is stricter???? Are there changes to the encoding or
whitespace when an XSD file is opened/transferred to Visual Web
Developer 2005 Express?

Have you tried to compare the original XSD vs. the one in Visual Web
Developer? In what way has it changed?
--
John Saunders [MVP]