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

[Nataraj S Narayan]

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?

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
>>
>