Connecting from a client application

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 window.

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.

Interactive SQL examples

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:

  • A server is currently running.
  • The default database has the login_mode database option set to accept integrated login connections.
  • An integrated login mapping has been created that matches the current user's user profile name or for a Windows user group to which the user belongs.
  • If the user is prompted with a window by the server for more connection information (such as occurs when using Interactive SQL), the user clicks OK without providing more information.
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0