Does anyone know of such a tool....

[Paul H Simonsen]

Try DB2XML. It can be found at
http://www.informatik.fh-wiesbaden.de/~turau/DB2XML/index.html .

prasadm at crt.com wrote:

> Hi All,
>
> We are currently in search of a tool on the web which accepts an SQL query
> as the input and gives us back an XML file containing all the results with
> the
> tags representing the column names of the table being queried.
>
> One such we found is Oracle's XSQL Servlet, but using this we can make only
> connections to Oracle database. What if we want to connect to a different
> database
> like say SQL Server, MS Access, etc.
>
> Another such tool we found is IBM's XML Lightweight Extractor, but this
> requires the
> query to be specified in a different manner i.e. a "xxx.dtdsa" file must
> contain the dtd
> of the resulting xml document and also the relationship between the tables
> used in the
> query. This seems to be of somewhat complex. Although IBM's XLE tool
> provides
> access to any database (viz. Oracle, DB2, etc) specifying the query in the
> required dtdsa format becomes difficult.
>
> Thanks for your time. If anyone knows of any tool, that takes a SQL
> query(select) as its
> input and returns an XML document, please share it with me.
>
> Thanks in Advance,
>
> Prasad M
> Home:-  630-595-0642
> Work:-  312-974-6543
> prasadm at crt.com <mailto:prasadm at crt.com>
>
> xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev at ic.ac.uk
> Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/ or CD-ROM/ISBN 981-02-3594-1
> Please note: New list subscriptions now closed in preparation for transfer to OASIS.

--
Paul



xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev at ic.ac.uk
Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/ or CD-ROM/ISBN 981-02-3594-1
Please note: New list subscriptions now closed in preparation for transfer to OASIS.