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<natara...@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.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
