[AccessD] Opening an XML recordset

Francisco Tapia fhtapia at gmail.com
Thu Aug 18 18:10:03 CDT 2005


I have an XML document that I obtain from a webservice, I was able to creat 
the schema and using XMLPad I can see that it is infact a valid document, 
(see below). However the error Message I get from Access (2000) is that 
"Recordset cannot be created. Source XML is incomplete or invalid."

How can I make the following document a valid xml document for opening as an 
ado recordset, ie:
rst.Open "C:\ShipVia.xml", "Provider=MSPersist;", adOpenDynamic, 
adLockReadOnly, adCmdFile


thanks,

I abbreviated the doc for simplyfing the post.

<?xml version="1.0" encoding="UTF-8"?>
<root xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
xmlns:od="urn:schemas-microsoft-com:officedata">
<xsd:schema>
<xsd:element name="ArrayOfWSShipViaItem">
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="WSShipViaItem" minOccurs="0" maxOccurs="unbounded"/>
</xsd:sequence>
<xsd:attribute name="generated" type="xsd:dateTime"/>
</xsd:complexType>
</xsd:element>
<xsd:element name="WSShipViaItem">
<xsd:annotation>
<xsd:appinfo/>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="ID" minOccurs="0" od:jetType="text" 
od:sqlSType="nvarchar">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="255"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Description" minOccurs="0" od:jetType="text" 
od:sqlSType="nvarchar">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="255"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>
<ArrayOfWSShipViaItem xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="
http://HAASService.org//WSAvanteData">
<WSShipViaItem>
<ID>10</ID>
<Description>FED EX P1176208147 (SKINNER)</Description>
</WSShipViaItem>
</ArrayOfWSShipViaItem>
</root>


-- 
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...



More information about the AccessD mailing list