Chapter 7

rappsc · July 18th, 2006, 11:15 PM

Has anyone else encountered problems with the Try it Out in Chapter 7 - Creating a Schema Collection? I have followed the instructions and even copied the Resume.xml and Resume.sql code files from the website. However, when I use the SSEUtil console and enter the !Run command, I receive an error that it already exists or the user does not have permission. Then when I run the query, it states one row is affected. When I then try to create the new table and columns on page 126, the Schema Collection property does not list the dbo.resume.xsd and it cannot be added. Even using the alternate commands in Listing 7-3 does not work. That states that ResumeXSD does not exist. Any help?

wib · October 26th, 2006, 06:28 AM

I've got exactly the same error

Have you had any more luck trying to resolve it?

Kind regards

Wib

rappsc · October 26th, 2006, 09:00 AM

No I never received a reply. I even tried e-mailing Wrox tech support directly and did not receive an answer. I finally just gave up.

Walraven · December 20th, 2006, 03:17 PM

I had the same problem and also gave up. I tried emailing one of the authors about two weeks ago about an earlier show-stopper and never received a reply.

TonyHe · December 30th, 2006, 08:20 PM

Hi guys, found the solution, use the following code as Resume.sql

Code:

Create XML Schema collection dbo.ResumeXSD AS 
N'<?xml version="1.0" encoding="utf-16" ?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">
<xs:element name="Name" type="xs:string"></xs:element>
<xs:element name="Objective" type="xs:string"></xs:element>
    <xs:element name="Address">
        <xs:complexType>
            <xs:sequence minOccurs="1" maxOccurs="1">
                <xs:element name="Street" type="xs:string" />
                <xs:element name="City" type="xs:string" />
                <xs:element name="StateProv" type="xs:string" />
                <xs:element name="Country" type="xs:string" />
                <xs:element name="PostCode" type="xs:string" />
            </xs:sequence>
        </xs:complexType>
    </xs:element>
<xs:element name="WorkExperience">
    <xs:complexType>
        <xs:sequence minOccurs="1" maxOccurs="unbounded">
            <xs:element name="ExpText" type="xs:string" />
        </xs:sequence>
    </xs:complexType>
</xs:element>
    <xs:element name="Reference">
        <xs:complexType>
            <xs:sequence minOccurs="1" maxOccurs="unbounded">
                <xs:element name="RefText" type="xs:string" />
            </xs:sequence>
        </xs:complexType>
    </xs:element>
</xs:schema>'
GO

That will work in SSEUtil sucessfully, but as for the other parts, I'm still working on them.

gricey · February 7th, 2007, 09:45 AM

Hi, How do you attach dbo.resumexsd to Rich.mdf?

keegrepus · March 2nd, 2008, 10:38 AM

OK...I think I finally got it!

First problem is the folder permissions...if most of you were like me, I didn't put all this stuff directly at the root level as suggested by the book. So, make sure that whatever folder you created is accessible to ALL users...I created a folder called c:\xmlexample on the root level and opened it completely.

Second problem is running the scripts using SSEUtil. I finally figured out that even if I set the console session to 'Use "c:\xmlexample\Rich.mdf"', running the scripts from within SSEUtil, executed the desired actions against the master database.

To check this, after you run the script...
1> Use master
2> Go

1> select * from sys.xml_schema_collections
2> Go

So, to get around all this, I opened up SQL Server 2005 Management Studio Express, attached to my database (the reason for the open permissions) made sure that Rich.mdf was the focus of the scripts and executed ALL (throughout the entire chapter) mentioned scripts from within the Management Studio.

This worked for me...good luck!

I was finally able to complete the chapter successfully.

No thanks to any of the authors or Wrox, of course.

Regards,

Greg