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

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+autoroot=clancor Next step is to parse and put it into a Sqlite database. Is it possible to bypass curl and do fully using

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

Hi I am getting the XML using # curl -v -u pilot:pilot http://remote-ip/handheld?sql=select+*+from+branchdesc+for+xml+autoroot=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

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

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+autoroot=my-mssql-database This connects to a remote MS SQL server based web service , may be using MIcrosoft IIS server.

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

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/

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

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,

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

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.

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

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+autoroot=my-mssql-database This connects to a remote MS SQL server

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

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