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...