skip to main content
Part 3: The 32-Bit Drivers : The XML Driver : Supported Tabular Formats for XML Documents
  
Supported Tabular Formats for XML Documents
The three main XML tabular-formats that the XML driver can access are described in the following table. 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 56. 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"><table xmlns="http://www.w3.org/1999/XMLSchema"
    xmlns:xsi=    "http://www.w3.org/1999/XMLSchema-instance"
    xmlns:rs=    "http://www.datadirect-technologies.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">