Ooops - Aplogies for posting a 2MB zip attachment

[Edwin Hannan]

Hello

On my previous post I attached my C10 solution for a web server and client I am testing and in my haste the lot went up as a 2MB zip file.

Now the thread will not open - is this now lost otr is the server thinking what do do with me:-)

Again apologies

Edwin

[Bruce]

Hi Edwin,

no it's not mad at you for the upload – it's a bug or something somewhere in the forum software we are using there which "blanks" a thread (for some users) when there are too many postings from a user. It's a pain, but unfortunately we don't know how to turn off the feature – which I guess is some sort of flame-preventing feature.

Usually I try and delete superfulous postings from threads that are getting long, but I missed this one.

The thread can still be seen if you go to it via a browser where you are not logged in.

I've posted the content of your last message here, and I have your zip file, so I should be able to post some sort of answer here.

cheers
Bruce

HI All

I have been trying to put together a webservice to insert leads into 2 tables in a database, I followed the Web77 example and have a basic webservice that functions on for REST and HTML POST (I can test post leads and they are inserted into the database table aip.TPS) but SOAP 1.1 and 1.2 fails.

I had this same issue back in Jan 2016 - see my previous post at http://www.nettalkcentral.com/index.php?option=com_smf&Itemid=36&topic=6718.0 where Bruce sorted me out and I managed to get it up and running and a 3rd party was able to post xml to the web service - that is running fine and ok - thanks Bruce.

I have been looking at this current issue for a few days now and still cannot get it to function..obviosly missing something 'obvious' but just can see it and I have another 3rd party that wishes to post xml data to another of my clients (into 2 tables, AIP and Central) and no luck but when I use soapUI I can post xml data successfully.

The 3rd party is using classic ASP - so I thought I would whip something together in clarion and do a quick post - hmmm err well not working out to well for me either.

Marcos has made a successful post to my test server ?(Thankyou Marcos), see precious post on this thread.

I have enabled debugview in all webservices and had a look at the output but really struggling to make sense of most of it :-)

I attach my solution, dct and aip.TPS / central TPS (2 Mb zip file) and hope if someone has the time to have a look and point me in the right direction - again

Many thanks

Edwin

[Edwin Hannan]

Hi Bruce

Many thanks for your help

Edwin

[Edwin Hannan]

Hi All

Any help at all much appreciated on the previous post where I attached my c10 solution, description of issues in previous posts

If anyone needs any more info, please let me know

Many thanks

Edwin

[Sibuya]

Hi Edwin,

I'm still testing some 3rd party Web Services using Visual Studio to see how to talk to NT Web Service.

Sorry but I couldn't use your example because I'm using Clarion 8 here.

At that time I could add records to your Web Service using NT sending an assembled SOAP message based on ASP page that you post from you customer.

That example was built in old ASP that uses Visual Basic Script that I have to do some corrections posted in my answer to you. Today they're using ASPX that uses .asmx pages to build SOAP messages using C# for example. But basically are the same.

If your customer that will consume NT Web Service follow the rules showed in on-line documentation that NT Web Service creates they can build a correct ASP or ASPX SOAP. As on-line doc is a page that you can open like: "https://81.133.172.229:8083/Database?dbLeads" and shows all the format and examples.

Using Visual Studio is different because it creates an internal class that assemble asyn or sync calls to all methods based on wsdl and some more info from the web service. It called as "Web Reference" or "Service Reference" component.

For example if I try to get Web Service or Web Reference from example web77 I can get all the tables and fields that I can use inside the project and set their values. But when I try to use your Web Service it don't get tables and fields just only methods. Seems to be some settings in your app to show files and fields to web service.

I've made a test creating Web Reference in Visual Studio to talk to Web77 and use NT. It worked creating a SOAP 1.1 xml message. I compare with on-line documentation and it's correct.

I've update NT to 9.09 and web77 is crashing but I think it's working.

Hope this helps you.

Cheers,

Marcos

[Sibuya]

Hi Edwin,

On the other side I've making some tests with Java Servers provinding Web Services. It's another thing.

Googling I saw that many people complains about Java programmers that do not cooperate so we have to work in SOAP message itself to build as the server is waiting for. In special I've some troubles with Secure Web Services with certificates...

Cheers,

Marcos

[Edwin Hannan]

Hi Marcos

Thank you for your time testing this :-) I really appreciate your input

I have had some recent success with using classic asp (some colleagues / friends in India have got it working) and I tested on a cloud server 2012 and IIS for the classic asp and a NT 9 web server,  just waiting to see if the 3rd party can now send xml using it in their environment :-)

I know it should not be difficult to connect to a NT web service and as you say it is all documented, so why is it difficult in some circumstances (such as mine??)

You mentioned:-
"For example if I try to get Web Service or Web Reference from example web77 I can get all the tables and fields that I can use inside the project and set their values. But when I try to use your Web Service it don't get tables and fields just only methods. Seems to be some settings in your app to show files and fields to web service."

Is there something not quite right with my app / web service? in what way do you think? If I am doing something wrong I need to know :-)

Many thanks

Edwin

[Sibuya]

Hi Edwin,

As I couldn't load you project I guess that it could be in you WebServiceMethod/Parameters/Fields that have fileds list for each file. Check to see if they are "highlighted" or selected. If so unselect fields that you want to include in your WSDL file or Documentation. See list header note.

If these fields are included in WSDL file, your customers can "see" your data fields to be referenced in your Web Service Methods when using tools like Visual Studio because these tools rely on this information.

The other way is constructing by hand-code in ASP for example the exact SOAP structure showed in on-line documentation that it works too.

Cheers,

Marcos