Re: Database application using HTTP

Hi Marc,

Thanks for responding. I was also exploring SQL 2005's capability of data
access using XML over the web browser. But I am unsure on how to first
create an ASP file that can output the XML result and use that as a stream
to parse in Delphi. And of course the need to create an XML and to send back
to SQL 2005 for updates. I need all the help I can get on this one.

Andy

"marc hoffman" <mh@xxxxxxxxxxxxxxx> wrote in message
news:46619851@xxxxxxxxxxxxxxxxxxxxxxxxx
Oliver Townshend wrote:
Then it's unlikely that you will get it running over HTTP, I don't
know of any databases that support an HTTP connection directly.

It would be a bit of a security hole wouldn't it. Send a DELETE or DROP
TABLE down the connection and do a fair bit of damage.

"connect via http" != "do everything, unauthorized, via http", i would
think?

depending on Andy's needs, SQL Server 2000/2005 allows to expose certain
data access via HTTP. i haven't used it (the HTTP access) myself, so i
don't know the extend of what can be done or whether it fits what Andy
needs t do, but its certainly worth checking out as an option...

hth,

--
marc hoffman
Chief Architect
RemObjects Software
http://www.remobjects.com

and the fifty-two daughters of the revolution
turn the gold to chrome


.

Relevant Pages

  • Dynamic Tables vs EAV
    ... Links for SQL Server Books Online: ... can essentially query and manipulate the nodes of the XML column sets using ...
    (microsoft.public.sqlserver.programming)
  • Re: Is there a way to convert ms sql 2008 tables to XML files?
    ... After looking at the code I made it work, since I removed 2 nVARCHARcolumns from the SQL statement where it is used as an RTF. ... I have the 2 XML files the bad and the good which are below: ... Verdana;}{\f1\fnil\fcharset0 Microsoft Sans ... Here is the actual string copied from the ms sql 2008 which works fine; ...
    (microsoft.public.dotnet.framework.aspnet)
  • thank you
    ... Unfortunately short of a clr proc or function you are unable to ... Change the maximum characters retrieved value for xml data. ... 'path provided by the stored procedure. ... 'If an error occurs catch the message and pipe it back to SQL ...
    (microsoft.public.sqlserver.programming)
  • Re: XML-Speicherung beim SQL Server 2005
    ... > also wenn die XML-Dokumente geparst werden, ... das der SQL Server dafür XQuery einsetzt. ... Struktur von XML. ...
    (microsoft.public.de.sqlserver)
  • Re: Implementation of boolean types.
    ... >> Marshall Spight wrote: ... I think of SQL as bringing the 3VL into popularity, ... world and XML will surely play I roll. ... XML doesn't address data management; ...
    (comp.databases.theory)