Solved

how acn i creat a web service in Visual FoxPro

Posted on 2011-03-20
12
496 Views
Last Modified: 2012-05-11
I must creat a ewb servic that consults a web site  and the results of the consulting must enter in my VFP program. How can i do that?
thanks
0
Comment
Question by:luciliacoelho
  • 5
  • 4
  • 2
  • +1
12 Comments
 
LVL 29

Expert Comment

by:Olaf Doschke
ID: 35175166
Consulting a website? What do you mean by that?
Independant on what the webservice should do, you can create and publish a web service in VFP by using the soap toolkit coming with VFP.

Ingredients are an IIS webserver, the COM server having all the methods you want to offer as the web service and the soap toolkit wsdl generator.

Haven't done that myself yet, but have a look into the soap toolkit help for more details.

Bye, Olaf.
0
 

Author Comment

by:luciliacoelho
ID: 35175616
Can everyone indicate a example code for this question?
Thanks
0
 
LVL 29

Expert Comment

by:Olaf Doschke
ID: 35175929
Soap Toolit comes with sample code. Read the help.

Bye, Olaf.
0
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 
LVL 29

Expert Comment

by:Olaf Doschke
ID: 35176011
Also see here in the VFP help is a walktrhough: http://msdn.microsoft.com/en-us/library/aza7ha5h(v=vs.80).aspx

Bye, Olaf.
0
 
LVL 12

Expert Comment

by:jrbbldr
ID: 35177917
I just finished a SOAP project and found that the 'other side' (the web side) wasn't anywhere close to a standardized utilization of SOAP.   They told me that they were, but when it came down to getting things to work, it was totally unique to their utilization of SOAP.

Basically I began with trying to get Toolkits and off-the-shelf ActiveX utilization sample code (Chilkat) to work and found that none of it would work the way THEY needed it to work.

After a LOT of going back and forth with the techies at the web site's office, I finally got things working.

The reason that I bring this up is that - YES you can get it to work.  BUT it MIGHT be a big challenge.

Good Luck
0
 
LVL 29

Expert Comment

by:Olaf Doschke
ID: 35179050
Jrbbldr,

that makes you many steps ahead of me, as I haven't published a webservice yet. I wonder what Chilkat ActiveX components would have to do with that, though.

The intention to PUBLISH/CREATE a webservice in VFP is to create a COM Server in VFP and deploy that to an IIS Server with an ASP or ISAPI listener handling requests towards that COM Server.

The Toolkit is surely founded on a rather old Soap standard, so eg don't expect the published webservices to be hostable by anything else but IIS via a generated ASP using MSSOAP.SoapServer30. This should also come out of the WSDL Generator. And don't expect it to be consumable by anything else but how Foxpro9 accessses webservices: Via MSSOAP.SoapClient30 - used within WSHandler class of _ws3client.vcx. Also see XML Web Services within the VFP Task Pane.

You may be better off in doing a nonstandard approach. You don't need the whole Soap standard to offer some functionality via a webserver.

Bye, Olaf.
0
 
LVL 12

Expert Comment

by:jrbbldr
ID: 35191375
I guess that I am just too cynical after struggling through the SOAP project to want to do anything more with an old 'standard' that doesn't seem to really be a standard at all.

Plus I can't say that project would be defined as a "web service" at all since it merely uploaded files to a recipient using SOAP (or at least the recipient's version of SOAP) and downloaded the results.   That to me is just another 'flavor' of a file transfer utility, not a "web service"

Regardless, I'd recommend that   luciliacoelho   do a Google search for:    vfp "web service"    or  vfp "web service" SOAP and see if there are any answers for you there.

Good Luck

0
 
LVL 2

Accepted Solution

by:
yoshua earned 500 total points
ID: 35220593
even if you don't like the answer but: don't use fox webservices.
- the SOAP-Toolkit doesn't work on 64Bit-machines
- The SOAP toolkit is no longer supported by MS
- there is a "logical error" in combination with proxy servers
  -> "you cannot connect a wsdl-file without a uid and a pwd, but if you want to pass uid and pwd you first must have access to th wsdl-file"
0
 

Author Comment

by:luciliacoelho
ID: 35412899
thinking about the yoshua coment, what is the solution to do that with vfp in 64 bits machines
thanks
0
 

Author Comment

by:luciliacoelho
ID: 35771715
I apologize for the insistence but still had no answer to my last question:
" how can i do that with vfp in 64 bits machines"
thanks
0
 

Author Comment

by:luciliacoelho
ID: 35950170
I apologize for the insistence but still had no answer to my last question:
" how can i do that with vfp in 64 bits machines"
thanks
0
 

Author Comment

by:luciliacoelho
ID: 36299029
Dear fellows,
I have turned another way. so far I had no problems. I'll explain it to you just in case you might know any shortage. Here it follows:
I have designed a php process to consume the web services
afterwards the php script processes data from the web services and inserts it into a VFP table.
The php script is invoked through a shell cmd file called from within the VFP code
So far there was only one issue has raised: VFP opened the answering table too fast, before php had updated it.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
Learn how to PXE Boot both BIOS & UEFI machines with DHCP Policies and Custom Vendor Classes
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question