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

Nataraj S Narayan natarajsn at gmail.com
Wed Aug 26 14:43:34 CEST 2009


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



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

More information about the fpc-pascal mailing list