>Hi All,
>
>I am trying to connect to a webservice from vfp9sp1. The programmer for the SQL Server db that I am connection to showed me how to connect to the webservice from vb2003, and gave me an install to put the database on my sql server. But I am not sure about the webservice. How can I even tell if the webservice is on my computer now?
The web service is never on your computer at any time. All you are doing is connecting to it, calling its methods and using it's return data, usually XML.
The webservice will always be on the server it was installed on.
>
>I tryed to do the wizard in vfp for webservices, but it only sees the WDSL webservice, none other.
You have not mentioned whether this is a .NET (asmx) web service. If it is, and this works for all, add ?WSDL after the webservice in the wizard.
The easiest way is to use the VFP TASK PANE - From the menu TOOLS|Task Pane. Once the pane opens, select the XML Web Services tab, and then click "Register a Web Service. In the box that appears enter your webservice address and the taskpane will register the service. If this is an ASMX service then type
http://www.mywevservice.address.com/servicename.asmx?WSDLNote that you cannot use this interface for a service with complex objects. However once the service is registered, you can select a method and VFP will generate template code for you to copy and use in your own program, where you can build the objects easily for transmission.
Bernard