How to expose data to clients over the internet?
am 18.03.2006 17:28:24 von DSmith1974
Is MySQL able to expose data to anyone with an XMLHttp request object,
similar to Microsoft's SQL Server (using IIS vitual directories, or
more recently native xml web services).
Many thanks,
Duncan.
Re: How to expose data to clients over the internet?
am 18.03.2006 19:41:51 von Bill Karwin
wrote in message
news:1142699304.598586.231260@j33g2000cwa.googlegroups.com.. .
> Is MySQL able to expose data to anyone with an XMLHttp request object,
> similar to Microsoft's SQL Server (using IIS vitual directories, or
> more recently native xml web services).
MySQL doesn't support any request/response traffic using the HTTP protocol.
You need to have an HTTP server, like IIS or Apache, and use your own web
application that writes SQL queries on behalf of a client, gets the results
from MySQL, and formats the results as XML to send in the web service
response.
MySQL support of XML consists of: the --xml options to the mysql and
mysqldump command-line tools (see docs). This allows the output of those
tools to be well-formed XML. But it doesn't receive web service requests or
send the response over HTTP.
Regards,
Bill K.