Supported Tabular Formats for XML Documents

The three main XML tabular-formats that the XML driver can access are described in Table 19-1. In some instances, you may need to define hints to help the XML driver read the tabular-format of an XML document correctly. See “Configure Location Dialog Box Descriptions”.

Table 19-1. Common Tabular Formats for XML Documents 

Format	Description
ADO 2.5 persisted files	These files are identified by a unique schema namespace URL. Although ADO uses the same data types defined by XML-Data, the data types use extensions, such as adding a maximum column width for string columns. ADO 2.5 persisted files are identified by the following unique XML element: <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882"     xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-     00AA00C14882"     xmlns:rs="urn:schemas-microsoft-com:rowset"     xmlns:z="#RowsetSchema">
DataDirect Format	This XML format conforms to the W3C recommendation for XML schema, Working Draft April 07, 2000. These files are identified by the following unique XML element (schema namespace URL): <table targetNamespace= "http://www.merant.com/namespaces/datadirect/xmlrecordset" xsi:schemaLocation= "<http://www.merant.com/namespaces/datadirect/xmlrecordset/EMP.xml>" xmlns="http://www.w3.org/1999/XMLSchema" xmlns:xsi= "http://www.w3.org/1999/XMLSchema-instance" xmlns:rs= "http://www.merant.com/namespaces/datadirect/xmlrecordset">
Microsoft Data Islands	These islands are identified by the <XML> tag in an HTML document. The Data Island can be embedded in the HTML document. Data Islands can include the following Schema definition and namespace: <Schema xmlns="urn:schemas-microsoft-com:xml-data" xmlns:dt="urn:schemas-microsoft-com:datatypes">