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

[Nataraj S Narayan]

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
>