XML OLE DB Provider 1.0
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
XML OLE DB Provider 1.0 Related Software
- DB SynchroComp
detects the differences between two SQL database schemas and synchronizes them - EMS DB Comparer for PostgreSQL
An excellent tool for database comparison and synchronization. - Alchemist XML IDE Professional
Alchemist XML IDE, is an advanced XML Integrated Development Environment. - XML Transmitter Pro
This low cost XML server lets you schedule the transfer of XML files. - Multi-DB Querier
Allows running the same SQL queries on multiple databases - CPathMonitor
Uses the FindFirstChangeNotification Win32 API to detect changes in a file path. - Cool Tabs
Includes DevStudio 6 and VisualStudio.NET folder tabs. - CFixedString
Implements a CString-like class with a fixed-length string buffer. - A LED control
A LED control. - ASMIL
ASM to IL compiler - GMail Drive shell extension
creates a virtual filesystem around your Google GMail account - Database wrappers Class
A set of classes wrapping the ODBC and OLE DB database APIs. - RTF Script Editor
A RTF based editor with syntax highlighting. - ASCII Desktop
This small utility displays your desktop as ASCII art. - HTML ListBox
A WTL list control which uses the HTML layout engine. - BVRDE
An IDE for remote compiling debugging UNIX and LINUX applications from Windows - Console Screen class
The class wraps the Win32 Console API. - Gmail Driver
Shell Namespace Extension that creates a virtual filesystem around Gmail account - XML OLE DB Provider
An OLE DB Provider allowing you to query XML documents with SQL. - Menu Button control
A menu button control. Ownerdrawn button painting. - ComboBoxes
Various ComboBox controls. - Script Studio
A remake of the Envox Studio application. - CShellLink
A small MFC class that wraps the Windows Shell's shortcut API. - Coloured controls
Extensions to most of the standard Windows controls with custom colouring. - MiniHTML control
A GDI based label control with text formatting. - Edit control (filter)
A simple subclassed EDIT control, which filters input. - HTML Source Bar
Shows parsed HTML, script code,style sheet source, image information o fbrowser. - PropertyGrid control
A simple WTL grid control. - Skinned Button control
A WTL version of Shinya Miyamoto's Window Blinds skinned button. - Alpha Play
A short walk-through of the alpha functions in Windows XP. - MultiSelect Tree View control
A tree with multi-select capabilities. - Non-Client control
Testing non-client painting in Windows. - PropertyList control
A WTL property list control; just like the one in MS Visual Basic. - Dialog Ed
Dialog Ed implements a dialog editor using the DHTML Editing Component. - WriteRes
Modifies the icon resource section of any application. - BaseScript
A scripting language with C or JavaScript-like syntax - Command Bar XP
An extension to the WTL Command Bar - Simple HTML Viewer
A RTF-based HTML viewer control. Extends the RichEdit control. - atldock
A basic docking windows framework for WTL.
XML OLE DB Provider 1.0 Publisher's Software
Popular Searches
Hot Downloads Software
New Release Software