[
Lists Home |
Date Index |
Thread Index
]
- From: "Paul H Simonsen" <psimonse@jcpenney.com>
- To: prasadm@crt.com
- Date: Thu, 13 Jan 2000 12:44:29 -0600
Try DB2XML. It can be found at
http://www.informatik.fh-wiesbaden.de/~turau/DB2XML/index.html .
prasadm@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@crt.com <mailto:prasadm@crt.com>
>
> xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev@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@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.
|
