Does anyone know of such a tool....

[prasadm at crt.com]

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.