Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

Hi All,

In SA 12.0.1.4134, the login_procedure option assigned the value of its login processing procedure.

In it, under certain conditions (let's call this condition X), I cause an error using raiserror or signal.

If I enter the database through my usual Win32 program or through ISQL, then in the case of "condition X" I see this error normally, i.e. I see both the error text and the code.

If I enter the database via a web-service via http, then in the case of "condition X" I see an error that I did not specify, but "401 Authorization Required".

Formally, SA is probably right, but I still would like to see exactly my mistake, so that I could distinguish it from just the wrong name or password when entering the database.

asked 06 Dec '18, 07:30

Stalker's gravatar image

Stalker
515293451
accept rate: 11%

I don't think the login procedure is called by web services... but I haven't run any tests to prove that :)

(07 Dec '18, 11:40) Breck Carter

If the web-service requires authorization, then the "login procedure option" is exactly called, I checked it.

(10 Dec '18, 09:19) Stalker
Replies hidden

Here's a wild guess: Maybe the post_login_procedure feature can be used.

(11 Dec '18, 07:45) Breck Carter
Be the first one to answer this question!
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:

×438
×24
×15

question asked: 06 Dec '18, 07:30

question was seen: 1,749 times

last updated: 11 Dec '18, 07:45