Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Connecting to a Database » Using integrated logins » Setting up integrated logins

Revoking integrated login permission Next Page

Connecting from a client application

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.

Interactive SQL examples

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 an integrated login mapping in a default database of a server:


The Interactive SQL statement CONNECT can connect to a database if all of the following are true: