When operating in Mixed mode, Adaptive Server allows both trusted, as with Named Pipes, and “untrusted” connections. It first examines the requested login name as specified by the client application, then handles the login depending on the information supplied.
Adaptive Server processes the login:
When the login name matches the mapped network user name, is null, or is composed of spaces, Adaptive Server treats the login attempt as a trusted connection and uses the rules for Integrated mode.
When the user supplies a different login name, Adaptive Server treats the login attempt as an untrusted connection and uses the rules for Standard mode.
Mixed mode offers users the convenience of login security integration without forcing all clients and applications to use that integration.
Existing applications that embed a hard-coded login name and password for all users continue to operate as before.
Other operating system clients, such as Apple Macintosh clients and UNIX-based workstations, also can access an Adaptive Server in Mixed mode.
Users accessing Adaptive Server over trusted connections can avoid a separate Adaptive Server password validation by omitting the user name and password in their login request.
Applications can be designed to send an empty login name field in the connection request, thereby avoiding a separate login step.