Error : Expected XML schema document

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Error : Expected XML schema document

Author

Topic

nishita_s
Yak Posting Veteran

61 Posts

Posted - 2008-12-17 : 01:01:08

I m creating xml schema collection by using following code.

This is giving error like Expected XML schema document

create xml schema collection logRecordschema as
'<schema xmlns="http://www.w3.org/2001/XMLSchema.xsd">
<element name="log">
<complexType>
<sequence>
<element name="application" type="string"/>
<element name="description" type="string"/>
</sequence>
</complexType>
</element>
</schema>'

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-17 : 01:08:56

something like below


create xml schema collection logRecordschema as 
'<?xml version="1.0" encoding="utf-16"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema.xsd">
<xs:element name="log">
<xs:complexType>
<xs:sequence>
<xs:element name="application" type="string"/>
<xs:element name="description" type="string"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>'

nishita_s
Yak Posting Veteran

61 Posts

Posted - 2008-12-17 : 02:05:12

Now error is like
unable to switch the encoding

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-17 : 02:10:22

then use some other encoding like utf-8

nishita_s
Yak Posting Veteran

61 Posts

Posted - 2008-12-17 : 03:23:17

for utf-8 again prev error : Expected XML schema document

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-17 : 04:06:09

what if you dont give it at all?


create xml schema collection logRecordschema as 
'<?xml version="1.0" ?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema.xsd">
<xs:element name="log">
<xs:complexType>
<xs:sequence>
<xs:element name="application" type="string"/>
<xs:element name="description" type="string"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>'

nishita_s
Yak Posting Veteran

61 Posts

Posted - 2008-12-17 : 05:37:19

giving same error: Expected XML schema document

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources