webclient function

[Baron]

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.

[Baron · Accepted solution]

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

[Baron · Accepted solution]

The answer was found Here!

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