[fpc-pascal] Parsing XML from MS SQL webservice using fpc

[Michael Van Canneyt]

On Fri, 28 Aug 2009, Nataraj S Narayan wrote:

> Hi
>
> I am getting  the XML  using
>
> # curl -v -u pilot:pilot
> "http://<remote-ip>/handheld?sql=select+*+from+branchdesc+for+xml+auto&root=clancor"
>
> Next step is to parse and put it into a Sqlite database. Is it
> possible to bypass curl and do fully using fcl-xml?

You can use synapse, lnet or Indy to download the data, and then parse it
with fcl-xml.

Michael.

>
> regards
>
> Nataraj
>
> On Wed, Aug 26, 2009 at 6:13 PM, Nataraj S Narayan<natarajsn at gmail.com> wrote:
>> Hi
>>
>> The customer want it that way. May be don't like to expose Sql server
>> to the world.
>> ITC of wrong validation,  browser shows:-
>>
>> ERROR: 401 Access Denied
>> HResult: 0x80046000
>> Source: Microsoft SQL isapi extension
>> Description: Access denied
>>
>> regards
>>
>> Nataraj
>>
>> On Wed, Aug 26, 2009 at 5:57 PM, Henry Vermaak<henry.vermaak at gmail.com> wrote:
>>> 2009/8/26 Nataraj S Narayan <natarajsn at gmail.com>:
>>>> Hi
>>>>
>>>> The following URL gives me a XML output  in any browser , after
>>>> validating username and password:-
>>>>
>>>>  http://"Some IP
>>>> address"/handheld?sql=select+*+from+branchdesc+for+xml+auto&root=my-mssql-database
>>>>
>>>> This connects to a remote MS SQL server based web service , may be
>>>> using MIcrosoft IIS server.
>>>>
>>>> Can i use "fcl-xml" package to send the query and then parse the xml output?
>>>
>>> Why don't you query the sql server directly?
>>>
>>> Henry
>>> _______________________________________________
>>> fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org
>>> http://lists.freepascal.org/mailman/listinfo/fpc-pascal
>>>
>>
> _______________________________________________
> fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org
> http://lists.freepascal.org/mailman/listinfo/fpc-pascal
>