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

SQL Anywhere 12.0.0 » SQL Anywhere Server - Database Administration » Starting and connecting to your database

 

SQL Anywhere database connections

A database connection forms a channel through which all activity from the client application takes place. Client applications cannot interact with the database server until a connection is made. When the database server connection is made, a user's permissions determine what actions the user is authorized to perform on the database server.

When a user connects to a database, the database server assigns the user's connection a unique connection ID. For each new connection to the database server, the server increments the connection ID value by 1. These connection IDs are logged in the database server message log, which records informational messages, errors, warnings, and messages from the MESSAGE statement. The connection ID can be used to perform the following tasks:

You can use the CONNECTION_PROPERTY function to obtain a user's connection ID by querying the Number connection property. See Number connection property.

 See also

Using connection parameters
Connecting with SQL Anywhere APIs
Connecting from desktop applications to a Windows Mobile database
Working with the Connect window
Sybase Central connection profiles
Creating ODBC data sources
Connecting to a database using OLE DB
Using Windows integrated logins
Kerberos authentication
Sample SQL Anywhere database connections
SQL Anywhere connection pooling
Temporary connections
Troubleshooting connections