Finding server password encryption properties

Question

1> how can i find whether server is accepting encrypted password or not from C program using sybase library(encryption set by sp_configure "net password enryption reqd",1), to make sure whether i should call function ct_con_props (CS_SEC_EXTENDED_ENCRYPTION) or not

Answer 1

master.. sysconfigures contains one row for every configuration parm, with its default values.

master.. syscurconfigs contains one row for every configuration parm that has been set on your server, and their runtime values.

Therefore:

SELECT ISNULL(value, 0)
    FROM  master.. syscurconfigs
    WHERE comment = "net password encryption reqd"

If it is 1 then it is set, otherwise it is not (default, 0)