On Fri, 28 Aug 2009, Nataraj S Narayan wrote:
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?
You can use synapse, lnet or Indy to download the data, and then parse it
with fcl-xml.
Michael.
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
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal
