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

Does anyone know of such a tool....

  • From: prasadm@c...
  • To: xml-dev@i...
  • Date: Thu, 13 Jan 2000 09:44:16 -0600

such a tool
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.



PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
 

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.


Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.