Trouble calling a SOAP service using SQL Anywhere

[Former Member]

Hi,

I followed the SQL Anywhere 12.0.1 tutorial below to create a SOAP service:

http://dcx.sybase.com/1201/en/dbprogramming/working-soap.html

I created the service and the client successfully. However, when I tried to call the service in the same way described in Lesson 3 of the tutorial, I got this error:

HTTP request failed. Status code '404 not found' SQLCODE=-983, ODBC 3 State="HY000" Line 1, column 1

I'm having trouble figure out why. I've confirmed that the server is listening on port 8082. From the error message, it appears that the SOAP service cannot be found.

I did exactly what the tutorial describes, with only one exception that both my service and my client are in the same database.

I would greatly appreciate it if someone could advise.

Thanks,

Calvin

[VolkerBarth]

I did exactly what the tutorial describes, with only one exception that both my service and my client are in the same database.

AFAIK, this "one exception" is the cause. To cite the docs:

A web client procedure is restricted from making an outbound HTTP request to itself; it cannot call a localhost SQL Anywhere web service running on the same database.

So I'd suggest to try with using two different databases.

[Former Member]

Thanks for your reply, Volker. I tried putting the service and the client in different databases on the same physical host. It still doesn't work. Is that supposed to work?

Thanks,

Calvin