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 parameter in the list of connection parameters to yes.

  • Specify neither a user ID nor a password in the connection string or connection dialog. This method is available only for Embedded SQL applications, including the SAP Sybase IQ 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 (deprecated), 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 a integrated login mapping in the database.