AuthType Does Not Return Integrated (only Standard) when login_mode = 'Standard,Integrated' is set.

[former_member644256]

I am checking for win integrated login as follows:

IF connection_property('AuthType') = 'Integrated' ....

but that always returns 'Standard'. When I set the login mode as follows...

SET OPTION PUBLIC.login_mode = 'Standard,Integrated'; 

it always returns 'Standard'.

When I set the login mode as follows...

SET OPTION PUBLIC.login_mode = 'Integrated'; 

it return 'Integrated' but I need the 'Standard' login active as well.

Any sugestions where am I going wrong?

[VolkerBarth]

To fully understand: Is it just he connection_property's return value that does not fit as expected, or is the issue that integrated logins should be allowed but do fail?

(FWIW, we use both modes with v16, and the connection property returns "Standard,Integrated" as expected.)

[former_member186998]

Hi Milan,

Which version is your SQL Anywhere?
In the case of version 10 or 11, there were the following modified histories.

Version 11:
================(Build #2142 - Engineering Case #557507)================
If the statement:
set option public.login_mode='Standard,Integrated'
was executed, it would have been recorded in the transaction log as
set option public.login_mode='Standard'
This could have affected mirroring environments where the login_mode was
set correctly on the primary server, but not on the mirror. This has been
fixed.

Version 10:
================(Build #3837 - Engineering Case #557507)================

When you use version 10 or 11, I recommend latest EBF to you.
2381119 - About the latest version of SQL Anywhere

Version 10: EBF 4310
Version 11: EBF 3158

Best regards,
Atsushi