A client application can connect to a database using an integrated login in one of the following ways:
If Integrated=YES is specified in the connection string, an integrated login is attempted. If the connection attempt fails and the login_mode database option is set to Standard,Integrated, then the server attempts a standard login. See login_mode option [database].
If an attempt to connect to a database is made without providing a user ID or password, an integrated login is attempted. The attempt succeeds or fails depending on whether the current user profile name matches an integrated login mapping in the database.
For example, a connection attempt using the following Interactive SQL statement succeeds, providing the user has logged on with a user profile name that matches an integrated login mapping in a default database of a server:
CONNECT USING 'INTEGRATED=yes';
The Interactive SQL statement CONNECT can connect to a database if all of the following are true:
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|