ASA Database Administration Guide
Connecting to a Database
Using integrated logins
Using integrated logins
A client application can connect to a database using an integrated login in one of the following ways:
Set the Integrated (INT) parameter in the list of connection parameters to YES.
Specify neither a user ID nor a password in the connection string or Connect dialog. This method is available only for Embedded SQL applications, including the Adaptive Server Anywhere administration utilities.
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 Mixed, the server attempts a standard login.
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 will succeed, providing the user has logged on with a user profile name that matches a 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 the following are true:
A server is currently running.
The default database on the current server is enabled to accept integrated login connections.
An integrated login mapping has been created that matches the current user's user profile name.
If the user is prompted with a dialog by the server for more connection information (such as occurs when using the Interactive SQL utility), the user clicks OK without providing more information.
A client application connecting to a database via ODBC can use an integrated login by including the Integrated (INT) parameter among other attributes in its Data Source configuration.
Setting the attribute Integrated=YES in an ODBC data source causes database connection attempts using that DSN to attempt an integrated login. If the LOGIN_MODE database option is set to Standard, the ODBC driver prompts the user for a database user ID and password.