webclient function

Baron — Tue, 01 Dec 2020 05:53:06 GMT

Could someone please help me why the below code not works?

create or replace function "V"."loginRequest"("SoapPayLoad" xml)

returns xml

url 'https://XXX.YYY.com:443/ZZZ/session'

type 'http:post:text/xml';

and once I call the function using

call loginRequest('myxml');

Then I get an error stating: The secure connection to the remote host failed: The connection was closed from the other side, SQLCODE=-990, ODBC 3 State="HY000"

At the begining I thought maybe my request is incorrect or the error is related to server, but once activating client log, then I see that the response from server is correct, so my request is correct and the resoponse is also exactly as expected, and the only problem is with calling this webclient function.

Re: webclient function

Baron — Tue, 01 Dec 2020 06:13:12 GMT

I am using SQL Anywhere 17 and also tried to add the line certificate 'file=*' in the definition of the webclient function, without success!!

Re: webclient function

Baron — Tue, 01 Dec 2020 06:26:09 GMT

The answer was found Here!

So adding set 'HTTP(VERSION=1.1)' to the definition of web client function

Question Re: webclient function in Technology Q&A

webclient function

Re: webclient function

Re: webclient function