Free XML OLE DB Provider 1.0 Download
Current Page: Home > Development > XML >

XML OLE DB Provider 1.0 Download

XML OLE DB Provider 1.0

License: Freeware Free
Downloads:
Publisher: viksoe.dk
File size: 169KB
OS: Windows XP, 2000, 98, Me
Date added: 2009-10-27
Homepage: http://www.viksoe.dk/
Category: Development

XML OLE DB Provider 1.0 Description

"An OLE DB Provider allowing you to query XML documents with SQL."


EditByBSEditor: This Provider allows any OLE-DB / ADO application to access data in tabular and hierarchical formats. Using standard structured query language (SQL) to query and retrieve XML data.
The Provider is built by using existing XML technologies. Specifically the Microsoft XML Parser 4.0 is required. Performance was never a consideration for this project.
The Provider deduces the table relations itself, so no additional information is required to describe how SQL relations are structured in the document (no additional schema information required).
It is possible to use AND and OR logical connectives to refine searches in the WHERE clause, as well as most arithmethic operators. It basically translates what you write into an XPath query so that should give you an idea of the limitations of the query processor.
The Provider is a read-only provider. It does not support INSERT, UPDATE or DELETE data manipulation.
There is no support for built-in functions, grouping or calculated column values. Nor does it support table and column aliases (they can be specified but are ignored). No aggregated functions are implemented.
Tables
XML excels at hierarchial structuring. SQL on the other hand tends to look at relations. It is not easy to mix the two or create a query language that seems natural for the other.
The XML Provider looks for repeating nodes at the same hierarchy level and treats them as tables. Meaning, all nodes that contain child nodes are potential tables.
It determines the columns available in the table by looking at the child nodes of the first entry it finds. you can free download XML OLE DB Provider 1.0 now.

XML OLE DB Provider 1.0 Keywords

provider, OLE DB, ole db provider, provide, xml ide

XML OLE DB Provider 1.0 Related Software

XML OLE DB Provider 1.0 Publisher's Software

    Software by Letter

    A B C D E F G H I J K L M N O P Q R S T U V W X Y Z Others

    New Release Software