On Fri, 28 Aug 2009, Nataraj S Narayan wrote:
Hi
I am getting the XML using
# curl -v -u pilot:pilot
"http:///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?
Hi
I am getting the XML using
# curl -v -u pilot:pilot
"http:///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
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
2009/8/26 Nataraj S Narayan :
> 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
Nataraj S Narayan wrote:
>
> May I have a lttle help? Didn't find any examples in fpc/packages/fcl-xml.
Oh, I wasn't sure if you simply wanted to parse the returned xml, or if
you wanted to talk to Web Service. Anyway, here is some links you might
want to take a look at.
http://wiki.lazarus.fr
Hi Graeme
May I have a lttle help? Didn't find any examples in fpc/packages/fcl-xml.
Need to know if anything special needs to be done to connect to
underlying SQL server? Or is it purely a webservice?
How do I specify username and password?
regards
Nataraj
On Wed, Aug 26, 2009 at 5:30 PM, G
Nataraj S Narayan wrote:
>
> Can i use "fcl-xml" package to send the query and then parse the xml output?
If the return result is xml, I can't see why not.
Regards,
- Graeme -
--
fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal
http://opensoft.homeip.net/fpgui/
__
