[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: Does anyone know of such a tool....

• From: "Paul H Simonsen" <psimonse@j...>
• To: prasadm@c...
• 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@c... 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@c... <mailto:prasadm@c...>
>
> xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev@i...
> 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@i...
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.

• References:
  • Does anyone know of such a tool....
    • From: prasadm@c...

• Prev by Date: RE: relation between CSS & XSL
• Next by Date: RE: String interning (WAS: SAX2/Java: Towards a final form)
• Previous by thread: Re: Does anyone know of such a tool....
• Next by thread: Re: Does anyone know of such a tool [SQL results as XML]
• Index(es):
  • Date
  • Thread