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.

asked 01 Dec '20, 05:53

Baron's gravatar image

Baron
2.1k134146175
accept rate: 46%

edited 01 Dec '20, 06:12


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

permanent link

answered 01 Dec '20, 06:13

Baron's gravatar image

Baron
2.1k134146175
accept rate: 46%

The answer was found Here!

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

(01 Dec '20, 06:26) Baron
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×64
×48

question asked: 01 Dec '20, 05:53

question was seen: 1,133 times

last updated: 01 Dec '20, 06:26