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.verm...@gmail.com> wrote: > 2009/8/26 Nataraj S Narayan <natara...@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@lists.freepascal.org > http://lists.freepascal.org/mailman/listinfo/fpc-pascal > _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
