XML, XSLT and XPATH

Schema: unknown attribute 'name' on relationship tag

Please support our XML, XSLT and XPATH advertiser: Intel Parallel Studio Home

•

Join Date: Oct 2007

Posts: 6

Reputation: n2201 is an unknown quantity at this point

Solved Threads: 0

n2201

Offline

Newbie Poster

Schema: unknown attribute 'name' on relationship tag

Jun 5th, 2008

I am trying to load XML files into SQL server database using SQLXML4.0

I have relation defined as such:

 Help with Code Tags 
 XML, XSLT and XPATH Syntax (Toggle Plain Text) 
		<xs:annotation>
			<xs:appinfo>
				<sql:relationship name="ApplicantPhone" 
						parent="Applicant" 
						parent-key="PQNumber" 
						child="Phone" 
						child-key="PQNumber" /> 
			</xs:appinfo>
		</xs:annotation>
		<xs:annotation>
			<xs:appinfo>
				<sql:relationship name="ApplicantPhone" 
						parent="Applicant" 
						parent-key="PQNumber" 
						child="Phone" 
						child-key="PQNumber" /> 
			</xs:appinfo>
		</xs:annotation>

and then I am using the relations as follows:

 Help with Code Tags 
 XML, XSLT and XPATH Syntax (Toggle Plain Text) 
<xs:element minOccurs="0" maxOccurs="unbounded" name="CustPhone" sql:relation="Phone" sql:relationship="ApplicantPhone">
     <xs:complexType>
          <xs:sequence>
               <xs:element minOccurs="1" maxOccurs="1" name="Area" type="xs:string" sql:field="Area"/>
               <xs:element minOccurs="1" maxOccurs="1" name="Exchange" type="xs:string" sql:field="Exchange"/>
               <xs:element minOccurs="1" maxOccurs="1" name="Number" type="xs:string" sql:field="Number"/>
               <xs:element minOccurs="0" maxOccurs="1" name="Extension" type="xs:string" sql:field="Extension"/>
          </xs:sequence>
     </xs:complexType>
</xs:element>
<xs:element minOccurs="0" maxOccurs="unbounded" name="CustPhone" sql:relation="Phone" sql:relationship="ApplicantPhone">
     <xs:complexType>
          <xs:sequence>
               <xs:element minOccurs="1" maxOccurs="1" name="Area" type="xs:string" sql:field="Area"/>
               <xs:element minOccurs="1" maxOccurs="1" name="Exchange" type="xs:string" sql:field="Exchange"/>
               <xs:element minOccurs="1" maxOccurs="1" name="Number" type="xs:string" sql:field="Number"/>
               <xs:element minOccurs="0" maxOccurs="1" name="Extension" type="xs:string" sql:field="Extension"/>
          </xs:sequence>
     </xs:complexType>
</xs:element>

When I run my vbs script to import the XML I get the error:

Help with Code Tags

(Toggle Plain Text)

Result State="FAILED"
HResult=0x80004005
Description=Schema: unknown attribute 'name' on relationship tag.
Source=Schema mapping
Type=FATAL

I would appreaciate your suggestion on fixing this issue.

Thanks

Last edited by n2201; Jun 5th, 2008 at 12:42 pm.

•

Join Date: Oct 2007

Posts: 6

Reputation: n2201 is an unknown quantity at this point

Solved Threads: 0

n2201

Offline

Newbie Poster

Re: Schema: unknown attribute 'name' on relationship tag

Jun 5th, 2008

I figured out. I was not using the correct table name in the relation. The error message sucks :-(

Quick Reply to Thread

Show Printable Version

Other Threads in the XML, XSLT and XPATH Forum

Previous Thread: open pop up window without Javascript enabled
Next Thread: Search certain word (need help)

Thread Tools	Search this Thread
Show Printable Version Email this Page

DaniWeb Message

Cancel Changes