Web service datawindow creation

[Former Member]

I'm trying to create my first datawindow with a web service as the data source and no matter what wsdl file I use I can't get past the "Select WSDL File" window. I've tried using a URL to the file and I also copied it locally. I tried our in-house build service and also some public soap web services such as the weather web service located at webservicesx.com. I used both http://www.webservicesx.com/globalweather.asmx and http://www.webservicesx.com/globalweather.asmx?wsdl.

I click the Next button my computer just beeps and stays on the window without displaying any kind of error message. I have imported the extensions from pbwdclient125.pbx.

I'm using Version 12.5.2 Build 5602 on Windows 7 64 bit.

I'm really lost here. Is there something else I need to do to be able to create a web service datawindow?

[Former Member · Accepted solution]

Hi Jack;

One of the first things you might like to do is see if your environment is ready to support Web Service development. An easy test for this is to open the DOS Command window and type in "WSDL.exe" at the command prompt.

  If the O/S does not respond to the WSDL command then its most likely the following issues:

a) The .NET SDK has not been downloaded or installed

b) You have the wrong .NET SDK installed (PB 12.5.x needs .Net 4.0)

c) You also have .Net 4.5 installed which may be interfering with .Net 4.0

d)  You do not have the .Net SDK in your System Path.

e)  You are running an AMD processor and need to download the SDK from AMD - not MS.

HTH

Regards ... Chris

[Former Member · Accepted solution]

Strangely we've been calling WCF web services from Powerbuilder Classic 12.5.2, Windows 7 64-bit (via datawindows) for the last year and if I enter WSDL into a command prompt it tells me WSDL is an unrecognized command. We have found many bugs in the implementation, but generally passing a WSDL to the datawindow generator has worked (can't say the same for setting the update / insert / delete though).

I do have .NET 4.5 installed (our WCF web services are written in it), I don't remember installing the .NET 4.0 SDK, but I did install all the PB.NET prerequisites, so it may have been done then, as well as multiple versions of Visual Studio.

Hope Jack can solve it soon, and let us know the answer here.

[Former Member]

Thanks to everyone that answered. I reinstalled PB and the SDK and it worked correctly.

[Former Member]

Excellent news!   

Have you hugged your Web Service DataWindow today? 

BTW: please mark your question as answered.

[Former Member]

Hi Chris,

Thanks for your help on this! I marked it as answered.

[CobyKako]

Hello Jack,

It works on my side with build 5751 and following url:

http://www.webservicex.net/globalweather.asmx?WSDL

Try first to test it using the Web Service wizard project an the .NET engine before using the WS DataWindow feature.

Also, ensure to have Windows SDK .NET Framework 4.0 installed in your systerm.

HTH,

Jacob

[Former Member]

Jack,

Are you sure the url is correct?  You have listed:

http://www.webservicesx.com/globalweather.asmx?wsdl

This url works:

http://www.webservicex.com/globalweather.asmx?wsdl

Or as Jacob pointed out, use:
http://www.webservicex.net/globalweather.asmx?WSDL

Thanks,
Beverly