Database application using XML

I am using TacHTTP and/or TMS TWebPost components to communicate with a SQL Server/IIS via ASP. Right now, I am doing very basic transfer of data and the workhorse is actually in the ASP itself. Now, I am challenged with larger transfer of data such as a resultset of a database query. How do I configure SQL Server, ASP and Delphi to work in XML? Basically, like the following:

- Delphi runs 'SearchRecords.asp' using the TacHTTP/TWebPost component by a defined URL
- ASP queries the SQL Server and gets a resultset in XML
- Delphi gets the response or result of 'SearchRecords.asp' in XML and uses a component to parse the data
- Data then get displayed in a grid

- Delphi runs 'AddRecord.asp' or 'UpdateRecord.asp' using the TacHTTP/TWebPost component by a defined URL using POST fields or maybe XML string
- ASP add or update the database using the POST or XML string

My tasks are as follows:

- how to set up SQL Server and get a working ASP example on how to retrieve, update, etc. a SQL Server database using XML
- what component to use in Delphi to parse XML efficiently in a database mindset

I would appreciate any suggestions or recommendations if someone has already achieve something like this. I thank you greatly in advance.

Andy

.

Relevant Pages

  • Re: ASP, Delphi and XML help
    ... call the method of your ActiveX and return the xml as response for ASP-page ... ActiveX's method (caled from ASP page) which will import your xml to ... I have both SMExport and SMImport. ... Delphi application and also to be able to send an XML from my Delphi ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: ASP, Delphi and XML help
    ... I have both SMExport and SMImport. ... any tips on how to pass the XML to and from an ASP page? ... Delphi application and also to be able to send an XML from my Delphi ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: ASP, Delphi and XML help
    ... I've never created an ActiveX with Delphi yet but I'll ... convert the resultset to xml. ... In your ASP ...
    (borland.public.delphi.thirdpartytools.general)
  • getdata.xml vs getdata.asp
    ... As I've started to use XML more extensively for data transfer to web ... requests to SQL Server. ... created ASP pages that return XML after using SQL Server to collect ... clearly has some important advantages over SQL Http requests, ...
    (microsoft.public.sqlserver.xml)
  • Re: Line/Paragraph Breaks in SQL Server/XML output
    ... How exactly are you outputing the file from the Stored Proc? ... the results of a FOR XML query as a string (this changes in SQL Server ... provider to retrieve the XML as a stream or DOMDocument in your ASP script. ...
    (microsoft.public.sqlserver.xml)